*1.6K*

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):

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

**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):

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