Dates to text

[Gary Thomson]

Is there a quicker way of converting a date to it's month
in text?

i.e. I enter the date 1-Feb-2004 in cell A1

In cell A2, I want the text "February" to appear.

At the moment, I am using a formula:

if(month(A1)=1,"January",if(month(A1)=2,"February", ,,

etc

Is there a shorter way??

I want the First letter to be Uppercase, the rest of the
letters to be lowercase.

Is it also possible to get a formula which would give all
the letters in Uppercase (i.e. FEBRUARY)??

 

[Andy B]

Gary

Try this:
=TEXT(B9,"Mmmm")

That will work if it is a proper Excel date.
=UPPER(TEXT(B9,"MMMM")) will give you the same in upper case.

Andy.

 

[Jackie Parker]

You could also use =month(A1) and format the cell to mmmm
through Format Cells + Custom

 

[J.E. McGimpsey]

Since MONTH() returns a value between 1 and 12, formatting it to
mmmm will always return January.