Display month name instead of number

G

Guest

I'm trying to display the month name abbreviation mmm instead of number. My
date is in cell C5 in the formula examples below.

If I use =TEXT(MONTH(C5),"mmm")
I always get Jan no matter what the actual date (ie 7/30/84 or 1/27/84)

If I use =TEXT(DATE(1900,C5,1),"mmm")
I get a month name but not the right one. For example
Actual Date Formula results
7/30/84 May
1/27/84 Dec
8/1/97 #NUM!
10/02/72 Jun
9/1/86 Jan

Any help will be much appreciated. Thanks.
Marcia
 
R

Ron Rosenfeld

I'm trying to display the month name abbreviation mmm instead of number. My
date is in cell C5 in the formula examples below.

If I use =TEXT(MONTH(C5),"mmm")
I always get Jan no matter what the actual date (ie 7/30/84 or 1/27/84)

If I use =TEXT(DATE(1900,C5,1),"mmm")
I get a month name but not the right one. For example
Actual Date Formula results
7/30/84 May
1/27/84 Dec
8/1/97 #NUM!
10/02/72 Jun
9/1/86 Jan

Any help will be much appreciated. Thanks.
Marcia
Click to expand...

=TEXT(C5,"mmm")


--ron
 

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.

Ask a Question

Similar Threads

Converting Number to Month in Text Problem 5
MONTH() Function 4
Extracting month from a date field 2
dates of month automation 3
Formatting 5
Find last day of month depending on criteria 12
Match + Index(?) Question 2
Excel 2002: How to get the number of days in the month ? 8

Top