giressh, with the date in A1, in another cell put =A1 and format the cell as
mmm to show only the month

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"gireesh" wrote in
message ...

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.


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