Date question
I have in column A numbers 1-12 all representing the months in a year.
When i put in this formula =month(B1)
i get the numbers of the months... Is there a formula that gives me only the
NAME of the month, NOT the number.
A1 equals "2" how can this number be changed to say "feb" instead of 2?
B1 2-04-07
|