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.
Add Months to a Date
Calculate years between dates
Calculate days, years and months from a certain date
Calculate age from date of birth
Calculate Minutes Between Dates & Time In Microsoft Excel
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.