I used the formula:


to calculate the month that occurs most frequently, and the answer is 11.
I need to convert 11 to November, but the formula:


leads to January. How can I convert my answer to November?

1 Answer 1


(Stolen from here)
You need to convert it to a date first, then extract the month:

=TEXT(DATE(2011,<your value here>,1),"MMM")

So in your case, this should be the formula:



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.