Spread Formula Reference
MONTH
Formula Functions > Functions M to Q > MONTH

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

Syntax

MONTH(date)

Arguments

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). For more details on the date inputs, refer to the discussion in Date and Time Functions.

Remarks

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

Data Types

Accepts numeric, string, or DateTime object data. Returns numeric data.

Examples

MONTH(L4)

MONTH(R4C12)

MONTH(366) gives the result 12

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

Version Available

This function is available in product version 1.0 or later.

See Also

DAY | EOMONTH | YEAR | Date and Time Functions