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
|