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:
- 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: