| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract the month of a date
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract name when a date in another cell gets near | Excel Worksheet Functions | |||
| Get month from date | Excel Discussion (Misc queries) | |||
| How do I break a date range by month? | Excel Discussion (Misc queries) | |||
| Round date to first of month | Excel Discussion (Misc queries) | |||
| HELP with this function | Excel Worksheet Functions | |||
Threaded Mode
