Display month name instead of number

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
dates of month automation 3
Formatting 5
Find the position of a date 6
4 SETS OF CRITERIA USED TO DISPLAY ANSWER 5
Match + Index(?) Question 2
calculate number of months 2
Calculating months 5

Back
Top