Convert Month Names to Numbers

Often, we'll have a list of month names that we want to convert to a date, or even just convert month names to numbers.

We can use the MONTH function to do this; see examples below:

How it works:

By concatenating a 1 to the text month name in column B we provide the MONTH function with a text date it can recognise/use. We can see how the formula in cell C7 evaluates in the Evaluate Formula dialog box below:

Convert Month Names to Dates

We can exploit this use of the MONTH function to create a date serial number (shown in column C below). You can then format them as a date (shown in column D below), using Format Cells.

Note: The formula in column C converts the month name in column B to the first day of each month in the current year. You can replace the 'YEAR(TODAY())' part of the formula with a different year, if you prefer.

Tip: You can also convert abbreviated month names to numbers or dates:

Resources

Affiliate Program

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

✕

Hang On, Don't Go Just Yet.

As a thank you for visiting how would you like a10% Discount Code to use with any of my courses?