# Thread: Last Month Thanks: 0 Likes: 0

1. ## Last Month

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.

2. ## Re: Last Month

Try:

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

3. ## Re: Last Month

Perfect!! thank you

4. ## Re: Last Month

Happy to help!

5. ## Re: Last Month

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

=MONTH(TODAY())-1

6. ## Re: Last Month

What if the current month is January?

7. ## Re: Last Month

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

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

8. ## Re: Last Month

Originally Posted by Eric W
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))