Return Month in word form. 12=December

[Dustin B]

I am creating an Excel worksheet and need to take a date and find the month
of the date to display in another cell. I can make it display the number
using the month(cellnumber) but what is the best way for it to display the
word instead; instead of 12 display December?

 

[Niek Otten]

Just format the (complete) date Custom as "dddd"

So, 12/12/2001, formatted as dddd, will display as December

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I am creating an Excel worksheet and need to take a date and find the month
| of the date to display in another cell. I can make it display the number
| using the month(cellnumber) but what is the best way for it to display the
| word instead; instead of 12 display December?

 

[Dustin B]

Well, that was a little too simple now wasn't it. I over complicated the
matter. Thanks for your help.

 

[Ron Rosenfeld]

Just format the (complete) date Custom as "dddd"

So, 12/12/2001, formatted as dddd, will display as December

If you are using an m/d/y system (eg English), then you should use mmmm for the
custom format
--ron

 

[Niek Otten]

Thanks, Ron! Fortunately the OP seems to have found the correct way

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| >Just format the (complete) date Custom as "dddd"
| >
| >So, 12/12/2001, formatted as dddd, will display as December
|
| If you are using an m/d/y system (eg English), then you should use mmmm for the
| custom format
| --ron