Returns the month corresponding to serial_number. The month is given as an integer, ranging from 1 (January) to 12 (December).
Syntax
MONTH(serial_number)
Serial_number is the date-time code used by Microsoft Excel for date and time calculations. You can give serial_number as text, such as "4-15-1993" or "15-Apr-1993", instead of as a number. The text is automatically converted to a serial number. For more information about serial_number, see NOW.
Remarks
Microsoft Excel for Windows and Microsoft Excel for the Macintosh use different date systems as their default. For more information, see NOW.
Examples
MONTH("6-May") equals 5
MONTH(366) equals 12
MONTH(367) equals 1