Formula Functions > Functions D to G > DAYS360 |
This function returns the number of days between two dates based on a 360-day year.
DAYS360(startdate,enddate,method)
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.
Use this function to help compute payments if your accounting system is based on a 360-day year (twelve 30-day months).
Accepts numeric, string, or DateTime object data for the two date arguments and boolean for the method argument. Returns numeric data.
DAYS360(B8,C8)
DAYS360(R8C2,R8C3)
DAYS360("7/15/2004","12/25/2004") gives the result 160
This function is available in product version 1.0 or later.
DAY | DATEVALUE | Date and Time Functions