Convert month name to a number in Google Sheets

How to convert a month name to a number string in Google Sheets?

GOOGLE SHEETS FORMULA TO CONVERT MONTH NAME TO A NUMBER

=MONTH(DATEVALUE(A2&"1"))

=MONTH(DATEVALUE(A3&"1"))

  • A2 = mmm format

  • A3 = mmmm format

If you have the month name stored as a text and want to extract the month number, the formula below will help you extract it.

Below how the result will look

CONVERT MONTH NAME TO NUMBER IN GOOGLE SHEETS
Convert month name to a number in Google Sheets

Convert month name to a number in Excel

How to convert a month name to a number string in Google Sheets?

EXCEL FORMULA TO CONVERT MONTH NAME TO A NUMBER

=MONTH(DATEVALUE(A2&"1"))

=MONTH(DATEVALUE(A3&"1"))

  • A2 = mmm format

  • A3 = mmmm format

If you have the month name stored as a text and want to extract the month number, the formula below will help you extract it.

Below how the result will look

CONVERT MONTH NAME TO NUMBER IN EXCEL
Convert month name to a number in Excel
TAGS:How to use MONHT formula in ExcelHow to use the DATEVALUE formula in ExcelHow to use the MONHT and DATEVALUE formula in ExcelFormula for month name to a number in ExcelChange month name to a number in ExcelChange Jan to 1 in Excel
TAGS:How to use MONHT formula in Google SheetsHow to use the DATEVALUE formula in Google SheetsHow to use the MONHT and DATEVALUE formula in Google SheetsFormula for month name to a number in Google SheetsChange month name to a number in Google SheetsChange Jan to 1 in Excel Google Sheets