DAYS360 (days between two dates)

<< 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:

DATEDIF, NETWORKDAYS, DAYS/DAYSP, TIMEDIFF