Excel MONTH function

Function              MONTH

Description        Excel MONTH function returns the month of a date value. The month is given as an integer, ranging from 1 to 12.

Syntax  MONTH (serial_number)

serial_number It is value in excel date format

Example: