Month function convert to string

Resolved · Medium Priority · Version 2007

Thu 10 May 2012, 12:22 Delegate 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:26 Trainer 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:09 Delegate 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:43 Trainer Doug said...

RE: Month function convert to string

Yes that works as well.

Doug
Best STL

Fri 16 Nov 2012, 12:08 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Using Alt in Save Dialog Box

When you are saving (or opening) a file, try these;
(Note the numbers are on the keyboard not the numeric keypad)
1. Go to previous folder Alt+1
2. Go up one folder level Alt+2
3. Search the Web Alt+3
4. Delete selected file Alt+4 or Delete
5. Create a new folder Alt+5
6. Cycle through all views Alt+6 repeatedly
7. Display the Tools menu Alt+7

View all Excel hints and tips