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.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.