Spread Formula Reference
Formula Functions / Functions D to G / EOMONTH
In This Topic
    EOMONTH
    In This Topic

    This function calculates the last day of the month (end of month) that is the indicated number of months before or after the starting date. Typically, this function is used to evaluate expiry dates, due dates and other dates that are supposed to land at the end of a month.

    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 the serial number for the last day of the month.

    Examples

    EOMONTH(A3,6)

    EOMONTH(R3C1,-4)

    EOMONTH("2019/02/13",2) gives the result 43585

    Version Available

    This function is available in product version 1.0 or later.

    Note: If a user uses LegacyBehaviors.CalculationEngine, EOMONTH function will return the DateTime object instead of the serial numeric value. For more details, please refer to breaking changes for legacy behaviors.

    See Also

    EDATE | MONTH | Date and Time Functions