In this article, we will learn how to convert the month name to a number in Microsoft Excel 2010.
While preparing reports there could be a requirement to convert a column that holds the name of the month (January, February, etc) into a number (1, 2).
Let us understand with an example:
We can use a combination of MONTH & DATEVALUE functions to get result.
In this way, we can convert the name of the month to the number of the month.
How to Add Months to a Date in Excel
How to Calculate years between dates in Excel
How to Calculate days, years and months from a certain date in Excel
How to Calculate age from date of birth in Excel
How to Calculate Minutes Between Dates & Time In Microsoft Excel
How to Calculate Months Between dates in Excel
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.