MONTH ( date-value )

Description: Computes the numeric Gregorian month for the date and/or time having the given date-value, taking into account the current date base value. That date and/or time shall be expressed either as a serial value, in which case, its fractional part is ignored, or as a string-constant having any valid date and/or time format, in which case, any time information shall be ignored.

Arguments:

Name	Type	Description
date-value	number, text	The date and/or time whose month is to be computed. That date and/or time shall be expressed either as a serial value, in which case, its fractional part is ignored, or as a string-constant having any valid date and/or time format, in which case, any time information shall be ignored.

Return Type and Value: number – The Gregorian month for the date and/or time having the given date-value, in the range 1900–9999.

However, if date-value is out of range for the current date base value, #NUM! is returned.

[Example:

MONTH(DATE(2006,1,2)) results in 1
MONTH(DATE(2006,0,2)) results in 12
MONTH("2006/1/2 10:45 AM") results in 1
MONTH(30000) results in 2 for both the 1900 and 1904 date base systems

end example]