Display month name instead of number
 

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

Display month name instead of number
 

=TEXT(C5,"mmm")

"Office User" wrote:

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

Display month name instead of number
 

On Tue, 9 Jan 2007 20:55:00 -0800, Office User
wrote:

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

Display month name instead of number
 

Thanks to both of you.

"Office User" wrote:

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