Month from the date?
 

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.

--
Nige Danton

Month from the date?
 

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?
--
David Biddulph

"Nige Danton" wrote in message
...
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.

--
Nige Danton

Month from the date?
 

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" wrote:

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.

--
Nige Danton

Month from the date?
 

On Dec 15, 7:35 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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

Month from the date?
 

On Dec 15, 7:42 pm, Tom wrote:
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.

--
Nige Danton

Month from the date?
 

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!
--
David Biddulph

"Nige Danton" wrote in message
...
On Dec 15, 7:35 pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
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