How can I extract a month from Excel date?
Hi Lee,
=U9, Format Custom as ddd
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Lee" wrote in message ...
|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
|
|