How to Convert a Number to Month Name

If you have a number and want to convert the number into a month name, you can put the number in a date as the month using the Date Function, then convert the date into a month with the Text Function.

When the number is greater than 12, the results equal to the remainder of the number divided by 12. For example, 13 divided by 12 will have a remainder 1, so number 13 and number 1 return the same month name of January.

To convert a number into month with full names, please use the following formula and change A2 to the cell in your file:


where 2011 can be any year after 1900.

To convert a number into month with 3 letters, please use the following formula:


One Response

  1. rama August 19, 2021

Leave a Reply