Get month from date using MONTH Function in Excel

MONTH function in Excel returns the month part of the date, when date is given as an input. MONTH Function in Excel takes date input in the form of

Reference to cells containing dates
Date Serial numbers
Date values returned from other Excel formulas
Date as a text input

Syntax for MONTH Function in Excel

MONTH (date)

date – A date from which month is to be extracted

Example of MONTH Function in Excel

Formula:

MONTH Function in Excel 1

Row number 2 and 3 are Reference to cells containing dates
Row number 4 is date serial number
In Row number 5, date is given as a text input
In Row number 6, date values are returned from DATE Formula

Result:

MONTH FUNCTION IN EXCEL 2