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
What am I doing wrong