Expression to get full name of previous month

[gls858]

I've figured out how to get the 3 letter abbreviation for
the present month, =Format(Now(),"mmm"), but I would like to have the full
month name of the previous month. Is this possible?

gls858

 

[Rick B]

=Format(Now(),"mmmm")

 

[Rick B]

Oops sorry, you wanted previous month.

Try


=Format(DateAdd("m",-1,Date()),"mmmm")

 

[gls858]

Oops sorry, you wanted previous month.

Try


=Format(DateAdd("m",-1,Date()),"mmmm")

Thanks Rick. Worked perfectly.

gls858