Excel Function : MONTH

Download now!

Excel Function : MONTH


Date and time


Converts a serial number to a month

Microsoft Excel Reference Page


Syntax and Description of the MONTH Excel Function

The MONTH function in Excel returns the month number for a given date. The syntax of the function is as follows: MONTH(date) where date is a date value.

About MONTH Excel Function

MONTH(serial_number) The MONTH function returns the month of a date represented by a serial number. The month is given as an integer between 1 (January) and 12 (December).