SpreadJS 14
Formula Reference / Formula Functions / Date and Time Functions / EOMONTH
In This Topic
    EOMONTH
    In This Topic

    This function calculates the date for the last day of the month (end of month) that is the indicated number of months before or after the starting date.

    Syntax

    EOMONTH(startdate,months)

    Arguments

    This function has these arguments:

    Argument Description
    startdate Starting date
    months Number of months before (negative) or after (positive) the starting date; if not an integer, the number is truncated

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

    Data Types

    Accepts numeric, string, or DateTime object data for the startdate argument and numeric data for the months argument. Returns a DateTime object.

    Examples

    EOMONTH(A3,6)

    EOMONTH(R3C1,-4)

    EOMONTH("2004/01/09",2) gives the result 3/31/2004 12:00:00 AM

    See Also