What is the syntax of MONTH Function in Excel?

The Excel MONTH function extracts the month from a given date as number between 1 to 12. You can use the MONTH function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function.

Purpose: Get month as a number (1-12) from a date
Return value: A number between 1 and 12.


=MONTH (serial_number)


serial_number - A valid Excel date.


To use the MONTH function, supply a date:

=MONTH("23-Aug-2012") // returns 8
=MONTH("11-May-2019") // returns 5