Table of Contents
To convert between month names and numbers in Google Sheets, you can use the MONTH function. This function takes a date as an argument and returns the corresponding number of the month. You can also use the TEXT function to convert a month number to a name. For example, the formula TEXT(A1,”mmmm”) will return the name of the month corresponding to the date in cell A1. Finally, you can use the DATE function to convert a month name to a number. For example, the formula DATE(2000,A1,1) will return the date in the year 2000 corresponding to the name of the month in cell A1.
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:
