Translate

29 December 2013

Name of previous month

To display the name of the previous month in an Excel cell, use the following formula:

=text(now()-day(now()),"mmmm")

As always, I welcome your comments.  Click on the Comment link below; it may say "No" or have a number in front of it.

No comments:

Post a Comment

Put comments here.