Excel Formulas to Extract the Month Number from Name!!
Tags: excelformula, excelformulas
Published: 2021-05-26 02:47:31

---
title: Excel Formulas to Extract the Month Number from Name!!
published: true
date: 2021-05-25 12:30:08 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-extract-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](https://www.microsoft.com/en-in/microsoft-365/excel)

[!["<yoastmark](https://geekexcel.com/wp-content/uploads/2021/05/Month-number-from-name.png)](https://geekexcel.com/excel-formulas-to-extract-month-number-from-name/month-number-from-name/#main)

## General Formula:

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

**=[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(“name”&1)**

## Syntax Explanations:

- **MONTH** – In Excel, the [**MONTH function**](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/) 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.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-34.png)<figcaption id="caption-attachment-45567">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-81.png)<figcaption id="caption-attachment-45566">Enter the formula</figcaption>

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

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-75.png)<figcaption id="caption-attachment-45565">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas: Check Last N Weeks of Today&#8217;s Date ~ Easy Solution!!](https://geekexcel.com/excel-formulas-check-last-n-weeks-of-todays-date-easy-solution/)**
- **[Excel Formulas: Check the Date is within a Last N months from Today!!](https://geekexcel.com/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?](https://geekexcel.com/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?](https://geekexcel.com/how-to-search-for-a-value-in-all-tabs-in-excel-office-365/)**