Convert 1-12 to a month name in Google Sheets or Excel

How to convert 1-12 number into a month name in Excel or Google Sheets?

FORMULA

=TEXT(A2*29,"mmmm")

=TEXT(A3*29,"mmm")

If you have the month name stored as a number ranging from 1-12 and want to extract the month name, the formula below will help you extract it.

The formula is compatible with Excel and Google Spreadsheet and will work on both.

Below how the result will look.

CONVERT 1-12 TO MONTH NAME IN GOOGLE SHEETS OR EXCEL

CONVERT 1-12 TO MONTH NAME IN GOOGLE SHEETS OR EXCEL