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

    This function returns the number of days between two dates based on a 360-day year.

    Syntax

    DAYS360(startdate,enddate,method)

    Arguments

    This function has these arguments:

    Argument Description
    startdate Date from which to calculate days
    enddate Date to which to calculate days
    method [Optional] Method for calculating days; if FALSE or omitted, uses U.S. (NASD) method; if TRUE, uses European method.

    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

    The methods for calculating the number of days can vary. The U.S. or NASD method works as follows:

    The European method considers starting dates or ending dates that occur on the 31st of a month to be equal to the 30th of the same month.

    Remarks

    Use this function to help compute payments if your accounting system is based on a 360-day year (twelve 30-day months).

    Data Types

    Accepts numeric, string, or DateTime object data for the two date arguments and boolean for the method argument. Returns numeric data.

    Examples

    DAYS360(B8,C8)

    DAYS360(R8C2,R8C3)

    DAYS360("7/15/2004","12/25/2004") gives the result 160

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    DAY | DATEVALUE | Date and Time Functions