Previous month date function in Excel

=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".

Read More..