98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Month function convert to string
Month function convert to string
Resolved · Medium Priority · Version 2007
Thu 10 May 2012, 12:22Delegate Danny said...
Danny has attended:
Excel Intermediate course
Month function convert to string
The month() function returns a number from 1-12, and i normally convert that into Jan-Dec using a lookup which lists number and month. Is there some sort of function which returns the month as a string (without formatting the date itself).
Thanks
Fri 11 May 2012, 16:26Trainer Doug said...
RE: Month function convert to string
Hi Danny
You could use the Choose function instead of a vlookup.
=CHOOSE(MONTH(A2),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")
where the cell A2 contains a date.
The function then returns the correct Month for a particular date.
Doug
Doug Dunn
Best STL
Fri 11 May 2012, 17:09Delegate Danny said...
RE: Month function convert to string
Will this do the same trick?
=text(A1*29,”MMMM”)
Where A1 from 1 to 12
Fri 15 Jun 2012, 14:43Trainer Doug said...
RE: Month function convert to string
Yes that works as well.
Doug
Best STL
Fri 16 Nov 2012, 12:08Trainer Simon said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Fri 23 Nov 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Using Alt in Save Dialog BoxWhen you are saving (or opening) a file, try these; |
