MONTH

This function returns the month corresponding to the specified date value.

Syntax

MONTH(date)

[Required] Specify the date argument as a number (as in 37806.5), a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4).

The month is returned as an integer, ranging from 1 (January) to 12 (December).

MONTH(L4)

MONTH(R4C12)

MONTH(366) gives the result 12

MONTH("12/17/2004") gives the result 12