MONTH(serial_number)
=MONTH("23-Aug-2012")
The MONTH function returns the month number of a given date. For example, this returns 8 because August is 8 in a year.
=MONTH("11-May-2019")
The MONTH function can take a date in any format and will still return the month number associated with the date. For example, this returns 5 because May is 5 in a year.
=MONTH(A1)
The MONTH function can also be used with a cell reference that contains a date. For example, if cell A1 contains the date "19-Feb-2016", the formula returns 2 because February is 2 in a year.
=MONTH(43183)
The MONTH function can also take a serial number as an argument. For example, this returns 11 because November is 11 in a year. The serial number 43183 corresponds to the date 11-Nov-2019.
=MONTH(DATE(2019, 5, 11))
The MONTH function can also be combined with the DATE function to return the month number of a date created from year, month, and day arguments. For example, this returns 5 because May is 5 in a year.
The MONTH function is used to extract the month of a date in the form of an integer (1 to 12). It can be used with either a serial number or a date provided by the DATE function or other formulas/functions.