Convert Between Month Name & Number in Google Sheets


You can use the following formulas to convert between month names and numbers in Google Sheets:

Method 1: Convert Month Number to Month Name

#convert month number in cell A1 to full month name
=TEXT(A1*29, "mmmm")

#convert month number in cell A1 to abbreviated month name
=TEXT(A1*29, "mmm")

Method 2: Convert Month Name to Month Number

#convert month name in cell A1 to month number
=MONTH(A1&1)

The following examples show how to use these formulas in practice.

Example 1: Convert Month Number to Month Name in Google Sheets

The following screenshot shows how to use the TEXT() function to convert month numbers (from 1 to 12) to month names (from January to December):

convert month number to month name in Google Sheets

Note that we can also use the “mmm” format to convert the month number to the abbreviated month name:

convert month number to abbreviated month name in Google Sheets

Example 2: Convert Month Name to Month Number in Google Sheets

The following screenshot shows how to use the MONTH() function to convert month names (from January to December) to month numbers (from 1 to 12):

convert month name to month number in Google Sheets

Note that this function will work on abbreviated month names as well:

Additional Resources

How to Extract Substring in Google Sheets
How to Combine Columns in Google Sheets
How to Count Number of Occurrences in Google Sheets

Leave a Reply

Your email address will not be published.