Hi
i would have thought that last month's month was Feburary and next month's
month was April ... however, here's two options
- returns Feburary
=TEXT(EOMONTH(NOW(),-1),"mmmm")
- returns April
=TEXT(EOMONTH(NOW(),1),"mmmm")
Note, to use the EOMONTH function you need to have the Analysis Tool-Pak
add-in installed (tools / add-ins)
Cheers
JulieD
"LyndieBee" wrote in message
...
I'd like to be able to evaluate the current date and have the name of the
previous month display in a cell. For example if I'm in cell A1 I want
the
statement to check today's date (March 8, 2005) and return last month's
month
"April". Can I accomplish this with an IF statement? Any other function?
Many thanks, Lyndie
|