How do I get a month name out of a numerical format? (5/1/2003 = May)

L

LordJezo

Say in one cell (B26) I have the data:

5/31/2004

In another cell on a different file I have the formula:

=YEAR([EMAIL_STATS.xls]Sheet1!$B$26)

That returns 2004 since in that cell on that linked sheet the dat
5/31/2004 is posted, so 2004 is returned.

Say I want to return the month name.

If I do

=MONTH([EMAIL_STATS.xls]Sheet1!$B$26)

I get back 5. How would I make it return May instead of 5
 
D

Domenic

Hi,

Try,

For the name of the month in full,

=TEXT([EMAIL_STATS.xls]Sheet1!$B$26,"mmmm")

For the abbreviated name of the month,

=TEXT([EMAIL_STATS.xls]Sheet1!$B$26,"mmm")

Hope this helps!
 
H

hcj

First, make a lookup table, 1-12 in first column, January-
December (Jan-Dec, whatever) in the second column.
Then use this formula instead:
=vlookup(MONTH([EMAIL_STATS.xls]Sheet1!
$B$26),lookuparray,2)

Hope this works for you.
 
L

Lukin

Instead of using =YEAR or =MONTH in your second file, could you jus
put:

=[EMAIL_STATS.xls]Sheet1!$B$26

and format the cell as mmmm in the Custom category
 
G

Gord Dibben

Lord

Don't use MONTH() Function

Use Text() Function

=TEXT(yourpath!B26,"mmmm")

Gord Dibben Excel MVP
 
Top