Question: what is the excel formula for months?
Answer: In case you want to get a month name rather than a number, you use the TEXT function again, but with a different date code: =TEXT(A2, "mmm") - returns an abbreviated month name, as Jan - Dec. =TEXT(A2,"mmmm") - returns a full month name, as January - December.