Spread WPF 15
Spread WPF Documentation / Formula Reference / Formula Functions / DAYS360
In This Topic
    In This Topic


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




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

    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.


    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.




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

    See Also