=MONTH(A1)
will return the month number (e.g., 8) of the date in A1.
=TEXT(A1,"mmm")
will return the 3-character month abbreviation (e.g., Aug) of the date
in A1.
=TEXT(A1,"mmmm")
will return the full month name (e.g., August) of the date in A1.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC www.cpearson.com
(email on web site)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.