Converting Serial Month Number to Text

[RLSSP]

I have a column that has the employees hire date. For example in cell A3 I have the hire date of 12/1/05 and in the column next to it I just want it to have the hire month for reporting purposes. So I used the formula =Month(A3) this returns the serial number for the month correctly. 12.... So then I do a custom format with the mmmm so it will say the month name and the only thing it will do is say January.

What am I doing wrong

 

[NBVC]

Try this

=TEXT(MONTH(A3),"MMMM")

Edit:

Sorry: should have been =TEXT(A3,"MMMM") as suggested by Oaktree

 

[Oaktree]

Use the TEXT formula

=TEXT(A3, "mmmm") for January

or =TEXT(A3,"mmmm yyyy") for January 2005

You are formatting the number 12 as mmmm, which returns January.

 

[Russ At Index]

Hi RLSSP , Welcome To The Board,

In cell A1 01/01/2005 ( Example )

Copy this into A2

=TEXT(A1,"mmm/yyyy")

HTH

Russ

 

[RLSSP]

It worked - Thank you!

It worked Thank you!

 

[sykes]

......... or just put:

= A3

in A4, then custom format A4 as mmmm.