The MONTH function returns the month of a date.
Formula:
=MONTH(serial_number)
Explanations:
Serial_number is required, the date you need to find the month.
Cautions:
Dates are stored as sequential serial numbers and January 1, 1900 is serial number 1.