| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract a month from Excel date?
I have a cell, U9 showing the date, custom formatted as dd-mmm-yy. e.g.
31-Oct-06 I need another cell to show just the month. e.g. Oct The formula =MID(U9,4,3) always returns a 2 digit number regardless of what date is in U9. I assume it is the Excel date value that the MID formula is taking the final two digits from. How do I get it to show the month as text. e.g. Oct Thanks, Lee |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
| excel array formula | Excel Worksheet Functions | |||
| date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
| Excel date field link to Word | Excel Discussion (Misc queries) | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
Threaded Mode
