Month from the date?

[Nige Danton]

I have a column of dates (mm/dd/yyyy) and want to return the month
e.g. 04/15/2007 and want a function that returns April. How do I do
that? Many thanks.

 

[David Biddulph]

If I wanted to be blunt, the answer would be RTFM.
To put it another way, why not try typing the word MONTH into Excel help?

 

[Tom]

Use a custom format and format the cells to "mmmm". If you want that month
returned in a different column, say into column B, then set column B to
custom format ("mmmm"), then =A1 in column B.

 

[Nige Danton]

If I wanted to be blunt, the answer would be RTFM.
To put it another way, why not try typing the word MONTH into Excel help?

Yes, thanks I did RTFM, but I'm looking for the name of the month
rather than the month number. Perhaps I missed something though. I'll
check again. Thanks for your help.

 

[Nige Danton]

Use a custom format and format the cells to "mmmm". If you want that month
returned in a different column, say into column B, then set column B to
custom format ("mmmm"), then =A1 in column B.

I'm a muppet. That's it exactly. Many thanks.

 

[David Biddulph]

Yes, sorry, I was asleep at the time. I'm glad you got a more useful answer
from folk who were more awake than I was!