How To Use The Month Formula In Excel
The Syntax of the MONTH Function The MONTH function in Excel returns a number between 1 and 12. This number corresponds to the month for the date in the selected cell or range. The syntax of the MONTH function is: MONTH(serial_number) The serial_number is the date from which you want to extract the month and must be a valid Excel date. How to Use Excel to Get a Month From a Date When your Excel worksheet contains a column of dates that are in a date format that Excel recognizes, use the MONTH function to extract the serial number for the month and place the serial number in a separate column....