Spread Formula Reference
Formula Functions / Functions M to Q / MONTH
In This Topic
    MONTH
    In This Topic

    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