Navigation:  Formula Reference > Spreadsheet Formula Functions >

MONTH

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

DAY

EOMONTH

YEAR