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
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
RE: Month function convert to string
Will this do the same trick?
=text(A1*29,”MMMM”)
Where A1 from 1 to 12
RE: Month function convert to string
Yes that works as well.
Doug
Best STL
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.
