<< Click to Display Table of Contents >> DAYS360 (days between two dates) |
Syntax:
DAYS360(StartDate, EndDate [, Mode])
Description:
Returns the number of days between two dates – based on a year with 360 days (12 months with 30 days each).
StartDate and EndDate are the two dates to be evaluated.
Mode (optional) is a logical value that lets you specify how dates occurring on the 31st of a month should be evaluated:
FALSE or omitted: The U.S. (NASD) method is used: If StartDate is the 31st of a month, the 30th of the same month will be used instead. If EndDate is the 31st of a month, the 1st of the following month will be used instead. Exception: If StartDate and EndDate are the 31st of a month, the 30th of the same month will be used instead (for both dates).
TRUE: The European method is used: If StartDate or EndDate is the 31st of a month, the 30th of the same month will be used.
Note:
Therefore, if you do not want to calculate according to the U.S. (NASD) method, the Mode argument must be specified with TRUE.
Example:
DAYS360("01/01/2018", "02/01/2018") returns 30
DAYS360("02/01/2018", "03/01/2018") returns 30
DAYS360("01/01/2012", "01/01/2013") returns 360
See also: