MONTH

Description

Returns the month that corresponds to the supplied date.

Syntax

MONTH ( number )

Parameter	Description
number	A date represented as: A serial number (for example 40339), which represents the DATEVALUE) Text (for example, "06-21-11" or "5-Jun-13")

Remarks

MONTH returns a number ranging from 1 (January) to 12 (December).

Examples

The following function returns 6:

MONTH("06-21-15")

The following function (where the serial date 41430 represents June 5, 2013) returns 6:

MONTH(41430)