Convert 1-12 to month names in Excel and Google Sheets

=TEXT(A2*29,"mmmm")

A2 = 1-12 number cells

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert 1-12 to month name in Excel

How to convert 1-12 to month names in Excel?
Convert 1-12 to month name in Excel

CONVERT 1-12 TO MONTH NAME — EXCEL FORMULA AND EXAMPLE

=TEXT(A2*29,"mmmm")

=TEXT(A2*29,"mmm")

💡 Click here to see, How to convert a month name to a number?

💡 Detailed month format explained here

Convert 1-12 to month name in Google Sheets

How to convert 1-12 to month names in Google Sheets?
Convert 1-12 to month name in Google Sheets

CONVERT 1-12 TO MONTH NAME — GOOGLE SHEETS FORMULA AND EXAMPLE

=TEXT(A2*29,"mmmm")

=TEXT(A2*29,"mmm")

💡 Click here to see, How to convert a month name to a number?

💡 Detailed month format explained here

Other widely used Excel and Google Sheets functions explainedOthers FormulasDate and time functionsNumber based criteriaText-based criteriaExtract functions