Month(now()) help!

[alancyoung]

Need some help with the MONTH(NOW()) Function, as I need it to reference the month preceding the current month.

Can anyone please help?

 

[Aladin Akyurek]

Need some help with the MONTH(NOW()) Function, as I need it to reference the month preceding the current month.

Can anyone please help?

Looks like one of

=MONTH(TODAY())-1

=EDATE(TODAY(),-1)

=DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

 

[Tom Urtis]

I don't know what you mean by "reference", but this formula in a cell thaqt is custom formatted as MMMM will display the prior month:

=TODAY()-DAY(TODAY())

 

[alancyoung]

Thanks this worked well.