Current Month minus 1 month

[brandon16]

Hi,

I need a formula to display current month minus 1 month.

I looked at using the =today() function but this won't be consistant.

 

[Special-K99]

=date(year(today()),month(today())-1,day(today())

 

[VoG]

Do you mean like this?

=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())),"mmmm")

 

[johnmpl]

Hi!

If you want the current date minus 1 month, you can use this formula:
=EDATE(TODAY(),-1)

If you want only the current month minus 1:
=TEXT(EDATE(TODAY(),-1),"mmmm")

Blessings!

 

[barry houdini]

Assuming you want the result today to be "August" try this formula

=TEXT(TODAY()-DAY(TODAY()),"mmmm")

or if you want the month number of last month (i.e. 8) then try this

=MOD(MONTH(TODAY())-2,12)+1

 

[Crazy billy]

(TEXT(TODAY()-30,"MMMM-YYYY"))

current month-year minus 1 .. adjust the value "30" for micro detail