Code for the month before this month

[herbertioz]

I have this code:

=UCase(MonthName(Month(Now())))

It prints out June, but I need it to print out May. How can I do that?

 

[plog]

=UCase(MonthName(Month(DateAdd("m", -1, Date()))

 

[jdraw]

MonthName(month(date)-1)

 

[herbertioz]

Thanks a lot, Plog! But I had to change it a bit to get it to work. The final code that works:

=UCase(MonthName(Month(DateAdd("m";-1;Date()))))