Display month name instead of number

[Office User]

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

 

[Teethless mama]

=TEXT(C5,"mmm")

 

[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

=TEXT(C5,"mmm")


--ron