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

previous-small MONTH Function in Excel                                                                                                                next_small MONTH Function in Excel