How to Convert Month to Number in Excel (3 Easy Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working in Microsoft Excel we might need to convert month to number for different purposes. Sometimes we need to convert to numbers for calculation advantages. In this article, I will share how to convert month to number in excel.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Easy Methods to Convert Month to Number in Excel

In the following article, I have described 3 simple and easy methods to convert month to number in excel.

Suppose we have a dataset of some Months’ names. Now we will convert these months to numbers using some functions and excel’s built-in features.

Convert Month to Number in Excel


1. Insert MONTH Function to Convert Month to Number in Excel

If you want to get a good result in a quick way then you must use functions to convert month to number in excel. Below I have converted to numbers applying two different functions.


1.1. Use MONTH Function

In this method, I have applied the MONTH function to convert month to number. Follow the steps below-

Steps:

  • In the first place, choose a cell. Here I have selected cell (D5).
  • Then, apply the following formula-
=MONTH(C5&1)

Where,

  • The MONTH function returns the number between 1 to 12 from a given date.

Insert MONTH Function to Convert Month to Number in Excel

  • After that, press Enter.
  • Further, drag the “Fill Handle” to fill all the cells.

  • As you can see we have successfully converted months to numbers performing a simple and easy function.

Insert MONTH Function to Convert Month to Number in Excel


1.2. Combine MONTH and DATEVALUE Functions

You can get your desired result using the MONTH function and the DATEVALUE function.

Steps:

  • Select the cell where you want to write the formula. For instance, we select cell (D5).
  • After that, put the formula down-
=MONTH(DATEVALUE(C5&1))

Where,

  • The DATEVALUE function returns a date-time code within the given string.

Insert MONTH Function to Convert Month to Number in Excel

  • Hit the Enter.
  • Pull the “Fill Handle” down to get the output.

  • Here we have our desired output in our hands with conversion to numbers.

Insert MONTH Function to Convert Month to Number in Excel

Read More: How to Convert Month Name to Number in Excel (5 Suitable Ways)


2. Apply Excel TEXT Function to Convert Month to Number

While working in Microsoft Excel you might find dates in various cells. Now you must be thinking about how you will convert them. Don’t worry. Go through the following steps to find your solution.

Step 1:

  • First, choose those dates and press Ctrl+1.

Apply Excel TEXT Function to Convert Month to Number

  • Accordingly, a new window will open named “Format Cells”.
  • Now, select custom and write “mmmm” in the “Type” section.
  • Click OK to continue.

Apply Excel TEXT Function to Convert Month to Number

  • Now we have only the month’s name in our hands.
  • Let’s convert them to numbers.

Step 2:

  • Choose a cell. Here I have selected cell (D5).
  • Then, write the formula down-
=TEXT(C5,"m")

Where,

Apply Excel TEXT Function to Convert Month to Number

  • Click the Enter button and drag the “Fill Handle” down to fill all the cells.

  • Finally, we have converted month to number using the TEXT function in excel. Simple isn’t it?

Apply Excel TEXT Function to Convert Month to Number

Read More: How to Convert Text to Number Using Formulas in Excel


Similar Readings


3. Use Format Cells Feature to Convert Month to Number

If you are looking for a way to convert month to number without using functions, then you are at the right place. You can use the format cells feature to convert month to number in excel.

Step 1:

  • Select the formatted dates from the table.
  • Click the icon of format cells from the ribbon.

Use Format Cells Feature to Convert Month to Number

  • From the pop-up window choose “Custom” and then write down “mmmm” in the “Type” section.
  • Subsequently, press OK to continue.

  • Likewise the previous method, we will get the month name only in the selected cells. Check out the screenshot, if you select any month name from the table it will show the date in the formula bar.

Use Format Cells Feature to Convert Month to Number

Step 2:

  • Now choosing the month names from the table press Ctrl+1 to open the “Format Cells” option again.

Use Format Cells Feature to Convert Month to Number

  • Here we will choose “Custom” and for this time we will put “m” in the “Type” section.
  • Furthermore, hit the OK button to continue.

  • Finally, we have converted months to numbers without applying functions.

Use Format Cells Feature to Convert Month to Number

Read More: Convert 3 Letter Month to Number in Excel (8 Suitable Methods)


Things to Remember

  • The TEXT function won’t work if you apply it over a month’s name directly. The TEXT function works over numeric dates only.

Conclusion

In this article, I have tried to cover all the simple methods to convert month to number in excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo