Dates to text

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

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)??
 
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.
 
You could also use =month(A1) and format the cell to mmmm
through Format Cells + Custom
 
Since MONTH() returns a value between 1 and 12, formatting it to
mmmm will always return January.
 
Back
Top