Excel Formulas to Extract the Month Number from Name!!

Sometimes, you may want to convert the month name to the number or the number to month name, such as convert January to 1. Here, we will show the quick tricks to extract the month number from the given month name in Excel. Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to extract the month number from the name, you can use the below formula.

=MONTH(“name”&1)

Syntax Explanations:

MONTH – In Excel, the MONTH function helps to return the month of a date.

Name – It specifies the input names from your worksheet.

Comma symbol (,) – It is a separator that helps to separate a list of values.

Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Refer to the below example image.

First, we will enter the input names in Column B.

Here we have to extract the month number from these input names.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Bottom-Line:

Hope you like this article on how to get the month number of the month name in Excel. If you have any doubt regarding this article or have any other questions related to Excel, let me know in the comments section below.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **

Excel Formulas: Check Last N Weeks of Today’s Date ~ Easy Solution!!

Excel Formulas: Check the Date is within a Last N months from Today!!

How to Find the Last Column of Data in Excel Office 365?

How to Search for a Value in All Tabs in Excel Office 365?