Converting Month Name to Number. To obtain the number of a month from its name, you can utilize the DATEVALUE function to create a date with the desired month’s name, followed by using the MONTH function to extract the month number. The formula used for this purpose is illustrated below: Formula for Obtaining Month Number … Continue reading Converting Month Name to Number