# How to return last quarter months?

1. ## How to return last quarter months?

Hi - I have the three formulas below that return April, May and June but will change to May, June and July once its August. Is there a way to keep those same three months until the 3rd quarter (September) is over?

``Please Login or Register  to view this content.``
``Please Login or Register  to view this content.``
``Please Login or Register  to view this content.``
Basically, I need to pull the previous quarter months. So if were in quarter 1 (January-March), I would need quarter 4 (October-December) to be returned.

2. ## Re: How to return last quarter months?

Please try at A3:A5

=TEXT(EDATE(TODAY(),1-MONTH(TODAY())+FLOOR(MONTH(TODAY())-1,3)-ROWS(A3:A\$5)),"mmm")

3. ## Re: How to return last quarter months?

Here is another formula that can be considered (place it in a cell and copy it down for two more cells)...

=TEXT(87*ROUNDUP(MONTH(TODAY())/3,0)-29*(3-ROWS(\$1:1)),"mmmm")

EDIT NOTE
----------------------------------------
For those of you who may be wondering about the underlying structure for the above formula, I discovered many, many, many, many years ago that you could get the month name from the month number using this structure...

=TEXT(29*MonthNumber,"mmmm")

4. ## Re: How to return last quarter months?

Another set of formulas:

=TEXT((MOD(CEILING(MONTH(TODAY()),3)+6,12)+1)*29,"mmmm")
=TEXT((MOD(CEILING(MONTH(TODAY()),3)+6,12)+2)*29,"mmmm")
=TEXT((MOD(CEILING(MONTH(TODAY()),3)+6,12)+3)*29,"mmmm")

5. ## Re: How to return last quarter months?

Thank you all for taking your time and responding, its nice to see multiple ways of getting the same result.

6. ## Re: How to return last quarter months?

If the OP wants to use 3 separate formulas instead of a single formula copied down, what I posted in Message #3 comes out as this...

=TEXT(87*ROUNDUP(MONTH(TODAY())/3,0)-58,"mmmm")
=TEXT(87*ROUNDUP(MONTH(TODAY())/3,0)-29,"mmmm")
=TEXT(87*ROUNDUP(MONTH(TODAY())/3,0),"mmmm")

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1