Names of previous three months

[asajnani]

Hi all,

I'm looking for way simple way to get the following information into one cell:

I need to know the month names of the previous three months.

So, if today's month is November, display text "Data is for months August, September, October."

Thanks in advance for your help!

 

[NARAYANK991]

Hi Sajnani ,

Will you have the month name "November" as text in a cell , or will you have a date such as 11/1/2013 ( in mm/dd/yyyy format ) ? Based on this , the formula will change.

Narayan

 

[asajnani]

Hi Narayan,

No, I won't have any data in any cells. I want it to auto-formulate every month I open the spreadsheet.

I think I need a cross between:

=UPPER(TEXT(TODAY(), "mmm"))
=EOMONTH(TODAY(),-3)+1

But can't figure out how to join it.

Thanks!

Hi Sajnani ,

Will you have the month name "November" as text in a cell , or will you have a date such as 11/1/2013 ( in mm/dd/yyyy format ) ? Based on this , the formula will change.

Narayan

 

[NARAYANK991]

Hi Sajnani ,

You can use the EDATE function as follows :

=A1&TEXT(EDATE(A2,-3),"MMMM")&","&TEXT(EDATE(A2,-2),"MMMM")&","&TEXT(EDATE(A2,-1),"MMMM")&"."

A1 has the text "Data is for the months of "
A2 has the formula =TODAY()

Narayan

 

[asajnani]

Thanks, Narayan. This definitely works!

Is there anyway to get the information into one formula without needing cells A1 and A2?

The text in A1 isn't full necessary.


Cheers!

Hi Sajnani ,

You can use the EDATE function as follows :

=A1&TEXT(EDATE(A2,-3),"MMMM")&","&TEXT(EDATE(A2,-2),"MMMM")&","&TEXT(EDATE(A2,-1),"MMMM")&"."

A1 has the text "Data is for the months of "
A2 has the formula =TODAY()

Narayan

 

[NARAYANK991]

Hi Sajnani ,

No problem , where ever A1 occurs , put in the text within quotes , and where ever A2 occurs , put in TODAY() , as follows :

="Data is for the months of "&TEXT(EDATE(TODAY(),-3),"MMMM")&","&TEXT(EDATE(TODAY(),-2),"MMMM")&","&TEXT(EDATE(TODAY(),-1),"MMMM")&"."

Narayan

 

[asajnani]

In case anyone ever needs it:

="Data is for months: " &TEXT(EDATE(TODAY(),-3),"MMMM")&", "&TEXT(EDATE(TODAY(),-2),"MMMM")&", "&TEXT(EDATE(TODAY(),-1),"MMMM")&"."

 

[asajnani]

Oh, thanks Narayan! I just figured it out myself too!