Solved: Month formula

[Marcster]

Hello People,

I was after a formula which returns the current month as text.
So I have this:
=CHOOSE(MONTH(TODAY()),"January","February","March","April","May","June","July","August","September","October","November","December")

Which does work like I want.

But now I want to use the formula to return the previous month's name
and the one before that and the one before that...
So cell
B4 displays January
C4 displays December
D4 displays November
etc...

How do I modify the above?.
Or is there an easier way?.

Thanks,

Marcster

[Bob Phillips]

B4: =TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-COLUMN()+2,1),"mmmm")

and copy across

[Marcster]

Thanks xld

:friends:

Marcster.

[Bob Phillips]

Slightly more robust

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-COLUMN(A1)+1,1),"mmmm")