Find start and end date of the last 5 quarters

**grsnipe** · 09-16-2013, 12:02 PM

Thanks to all that help

I am working on a report for equipment usage. I need it to display the start and end dates for the last 5 full quarters. Also this has to be usable for future reporting. How do I find the start and end dates for the last 5 full rolling quarters. The second part would be to label the quarters. Please see the attached example.

Thanks

**mehmetcik** · 09-16-2013, 01:49 PM

Try this formula in G3 to find the last date in the last complete quarter

Please Login or Register  to view this content.

This formula in G4 finds the last date of the previous quarter to the date in G3, fill down to find earlier dates.

Please Login or Register  to view this content.

This formula in f3 will find the start date of the quarter whose last date is in column G. Fill down to find earlier dates.

Please Login or Register  to view this content.

Find start and end date of the last 5 quarters

LinkBack

Thread Tools

Rate This Thread

Display

Find start and end date of the last 5 quarters

Re: Find start and end date of the last 5 quarters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find start date and end date for the employee

[SOLVED] Find date using start date and number of network days

Find start date of the month

Given an end date find corresponding start date 3 months prior ..quarter date range

Fiscal Quarters with July as your start

Bookmarks

Bookmarks

Posting Permissions