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

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:

May 29, 2024
May 13, 2024
April 25, 2024

## One Reply to “Convert Between Month Name & Number in Google Sheets”

1. Wed says:

When converting the month number to full month, the formula below works. But can you please explain why we multiply by 29?

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