Previous month based on current month

[spectraflame]

I am using the following formula to return the current month.

=TEXT(TODAY(),"MMMM")

However I would like to return the previous month. I know that if it were the year, I can just add -1 to the end of the formula, but that returns #VALUE when tried with the MMMM format.

Thanks,
Matthew

 

[RajeshKumar25]

A very simple solution is Text(A2-28,"mmmm")
A2 refers to the cell where date is.
Or Text(Now()-28, "mmmm")

-28 is to get to prior month adjusting for February, since date does not matter, we just extract the right month.
This avoids lots of checks for Jan/ December, or trickery on formulas.

 

[Rick Rothstein]

A very simple solution is Text(A2-28,"mmmm")
A2 refers to the cell where date is.
Or Text(Now()-28, "mmmm")

-28 is to get to prior month adjusting for February, since date does not matter, we just extract the right month.
This avoids lots of checks for Jan/ December, or trickery on formulas.

I don't remember this thread in detail, but a quick review seems to indicate a desire to get the previous month's name. For the formula you posted, if NOW() is the 29th, 30th, or 31st of a month, subtracting 28 will return the current month name, not the previous month's name.