In this article we will learn how to convert 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 combination of MONTH & DATEVALUE functions to get result.
In this way we can convert name of month to the number of month.
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.