=month(now())-1
The excel formula above will display the previous month from the current within excel. So, if the current month is February. Then Excel will display the word "January".
The excel formula above will display the previous month from the current within excel. So, if the current month is February. Then Excel will display the word "January".
1 comments:
Hmm. The current month is March, so I want February to show. When I insert the above code, all that shows is "2". Of course, I'm assuming "2" is referring to February, but I don't want the number of month. I need the name of month. =P
Post a Comment