Excel Function : MONTH

Download now!

Excel Function : MONTH

Category

Date and time

Description

Converts a serial number to a month

Microsoft Excel Reference Page

https://support.office.com/en-us/article/MONTH-function-579a2881-199b-48b2-ab90-ddba0eba86e8

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).