month name

[pat67]

There is a function to show the number of the 1-12. Is there a way to
show the name?

 

[David Biddulph]

=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1

 

[pat67]

=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1
--
David Biddulph






- Show quoted text -

Thanks

 

[Bernard Liengme]

If a cell is displaying a date (let's say 1/1/2010) and I give it the custom
format of "mmm" (without quotes) will display the month name abbreviation
A custom format of "mmm" will display the full name
Suppose A1 holds a date and B1 has =A1, then the custom formatting will show
the name of month as above
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/office/default.aspx#tab=4

 

[T. Valko]

=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1

If you have just the month number 1 to 12:

=TEXT(A1*29,"mmmm")