Convert month name to number in Excel and Google Sheets

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

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert month name to number in Excel

How to convert month name to number in Excel?

CONVERT MONTH NAME TO NUMBER — EXCEL FORMULA AND EXAMPLE

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

💡 How to convert 1-12 to a month name?

💡 Detailed month format explained here

Convert month name to number in Google Sheets

How to convert month name to number in Google Sheets?
Convert month name to number in Google Sheets

CONVERT MONTH NAME TO NUMBER — GOOGLE SHEETS FORMULA AND EXAMPLE

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

💡 How to convert 1-12 to a month name?

💡 Detailed month format explained here