Exceljet

Quick, clean, and to the point

Excel MONTH Function

Excel MONTH function
Summary 

The Excel MONTH function extracts the month from a given date as number between 1 to 12. You can use the MONTH function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function.

Purpose 
Get month as a number (1-12) from a date
Return value 
A number between 1 and 12.
Syntax 
=MONTH (date)
Arguments 
  • date - A valid Excel date.
Usage notes 

The MONTH function extracts the month from a given date as number between 1 to 12. For example:

=MONTH("23-Aug-2012") // returns 8
=MONTH("11-May-2019") // returns 5

You can use the MONTH function to extract a month number from a date into a cell, or to feed a month number into another function like the DATE function. See below for more examples of formulas that use the MONTH function.

Note: dates are serial numbers in Excel, and begin on January 1, 1900. Dates before 1900 are not supported. To display date values in a human-readable date format, apply a the number format of your choice.

Notes

  • Date must be a valid Excel date.
  • MONTH will return a #VALUE error on text values.