Excel MONTH Function

Using the Excel MONTH Function


The MONTH function in Excel is used to provide the month of a date that is provided in serial format. The month is returned as an integer that ranges from 1 (January) to 12 (December). MONTH can be used to extract the month from a date into a cell of its own or used as input to another formula or function.


=MONTH (serial_number)

Syntax Breakdown

A required field that contains the date that includes the month you would like to find. Dates entered as text can cause problems. It is therefore advisable to enter the date using the DATE function or use the output from another formula or function.

Excel MONTH Examples

Usage Notes

Excel Gregorian Values
In Excel, values returned by the MONTH and other date functions default to using Gregorian values. If the display format for the date is set to another setting the function will return the value associated with the equivalent Gregorian date.

Excel Date Ranges
Excel will only recognize dates that are between January 1, 1900 and December 31, 9999. In serial format these date ranges are 1 and 2958465. Going above or below these date ranges will cause the MONTH function to throw a #NUM! error.

Excel MONTH Error