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

Get FREE Advanced Excel Exercises with Solutions!

In terms of working with Microsoft Excel, we might face the necessity of converting month name to number. There is no need to panic. We can do it quite simply. For this, we just need to follow some sequential procedures. In this article, I am going to discuss 5 effective ways on how to convert month name to number in Excel. I hope it will be easy to understand and then, apply later.

Table of Contents hide

Download Practice Workbook

5 Suitable Ways to Convert Month Name to Number in Excel

1. Use MONTH Function

2. Combine MONTH & DATEVALUE Functions

3. Apply MONTH Function with Symbol

4. Adopt MATCH Function

5. Use TEXT Function

Practice Section

Conclusion

Download Practice Workbook

Convert Month Name to Number.xlsx

5 Suitable Ways to Convert Month Name to Number in Excel

There are so many quick, effective, and simple ways to convert month name to number. I am going to discuss 5 of them in this article.

For more simplification, I am going to use a dataset where I have some month names in a column with a serial number column. I am going to convert the month name to number in the Month Number column.

1. Use MONTH Function

We can use a built-in function named the MONTH Function to convert month name to number. Just follow the following steps to execute the purpose.

Steps:

Select a preferred location first. I have chosen cell D5 for this purpose.
Next, input the following formula in that cell.

=MONTH(C5&1)

Press ENTER to have the converted output.

Finally, use Fill Handle to AutoFill the rest cells.

2. Combine MONTH & DATEVALUE Functions

A combination of MONTH and DATEVALUE functions can be another effective way to convert month name to number.

Steps:

Pick a cell and write the formula mentioned below in that cell.

=MONTH(DATEVALUE(C5&1))

After that, hit the ENTER button.

AutoFill the rest cells.

3. Apply MONTH Function with Symbol

In order to convert month name to number, we can also apply the MONTH function with Double Hyphen (–) symbol. You can follow the following procedure to do it perfectly.

Steps:

Firstly, select a cell and input the formula mentioned below in that cell.

=MONTH(--(C5&1))

To have output, press ENTER.

For the remaining cells, use AutoFill.

Similar Readings

4. Adopt MATCH Function

The MATCH function can be another handy function to convert month name to number. Just follow the following steps in a sequence.

Steps:

Select a preferred location first. I have chosen cell D5 for this purpose.
Next, input the following formula in that cell.

=MATCH(C5,{"January","February","March","April","May","June","July","August","September","October","November","December"},0)

Next, press ENTER.

Lastly, apply AutoFill for the remaining cells.

5. Use TEXT Function

We can also use the TEXT Function to fulfill our purpose of converting month name to number.

Steps:

Pick a cell and write the formula mentioned below in that cell.

=TEXT((C5&1),"m")

Along with that, hit the ENTER button.

Finally, use Fill Handle to AutoFill the rest cells.

Practice Section

For more expertise, you can practice here.

Conclusion

At the end of this article, I like to add that I have tried to explain 5 effective ways on how to convert month name to number in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.

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

Download Practice Workbook