Excel enables us to convert month name to a number, by using the two functions MONTH and DATEVALUE. Figure 1. Final result: Convert Month Name to Number Syntax of MONTH function =MONTH(serial_number) serial_number - the date whose month we are trying to find; Dates should be entered in a...
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.