Extracting the Month from the Date in other cell
Remeber that these are really numbers (well I hope they
are) You can either covert these to a month by entering a
formula:
=TEXT(A1,"MMM") - short month name
=TEXT(A1,"MMMM") - full month name
Or you could use a custome format ad just type MMM or MMMM
into the input field in the format cells, number, custom.
|