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