Last Month

[PCRIDE]

Any good way to get Last Month as a month number using today's date? Previously I've done =NOW()-32 and that seems to work, but without figuring it out you could run into a day in a month where this fails? Like the first day of the month would take you back 2 months until you hit the 2nd or 3rd day of the new month.

 

[Eric W]

Try:

=MONTH(EOMONTH(TODAY(),-1))

 

[PCRIDE]

Perfect!! thank you

 

[Eric W]

Happy to help!

 

[Peter_SSs]

Just this should do it too, shouldn't it?

=MONTH(TODAY())-1

 

[Eric W]

What if the current month is January?

 

[Rick Rothstein]

Disadvantage is that there are two calls to the TODAY function but, with that said...

=MONTH(TODAY()-DAY(TODAY()))

 

[Peter_SSs]

What if the current month is January?

I rushed in there Eric didn't I? (I often do with date questions )

So an alternative, but no better than yours, might be?
=MONTH(EDATE(TODAY(),-1))