SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / 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 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