Hi

It sounds as though you have not put =A1 into cell B1
If the cell is empty, Excel assumes 01/01/1900 if a date format or function
hence it would keep returning Jan if empty.

Regards

Roger Govier


JMay wrote:
I've entered all months of the year,
from 01/15/05,,,,,, to 12/15/05
in Cell A1 (one at a time of course)
Each time my cell B1 =month(A1)
yeilds 1,,,,,,,12 << Great (as expected).
But when I format B1 as Custom "mmm"
they come out Jan,,,,,,,,,Jan
What's my problem?
TIA,

"Bryan Hessey"
wrote in message
news:Bryan.Hessey.1yy79a_1132746601.0002@excelforu m-nospam.com...

Rightmouse and Format Cell to Custom format = mmm

then =Month(A1)

shoud give you your required answer.



gireesh Wrote:

I want to extract the month of a date. for example I have date
"6/5/2005" which is in "mm/dd/yyyy" format. i want to get the month
part of the date as "Jun". Similarly for the date "8/12/2005" as
"Aug".

Presently I am doing this with the help of VLOOKUP approach with a
table having these values.

As i am having a huge volume of data to work with a quicker and easier
formula can be a great help.

Thank you.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=487578