Convert Month Name to Number

This tutorial will demonstrate how to convert a Month name to it’s corresponding number in Excel and Google Sheets.

Month Name to Main

Convert Month Name to Number

The first question to ask yourself when converting a month name to a number is: Is my month name stored as text?

If your month name is stored as text you can use the MONTH and DATEVALUE Functions to convert the month name, but if the month isn’t stored as text than you only need to adjust the formatting…

Month Name to Number – Formatting

If the cell containing the month name is right-aligned then the cell may contain a date that is formatted as a month:

Month name

Simply change the date format from MMM (abbreviated name) or MMMM (full name) to M (month number, no leading zero) or MM (month number, with leading zero).

Month Format

You can change the date format from the Cell Formatting Menu:

custom number formats excel

Type “M” or “MM” in the Type area.

To access the Cell Formatting Menu use shortcut CTRL + 1 or press this button:

number format button

Month Name to Number – Functions

If your month name is stored as text then you can use this formula containing MONTH and DATEVALUE to calculate the month number:

Month Name to NumberConvert Month Name to Number in Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Month Name to google sheet