DAYS360

Returns the difference between two dates based on the 360 day year used in interest calculations.

Syntax

DAYS360(Date_1;Date_2;Type)

If Date_2 is earlier than Date_1, the function will return a negative number.

The optional argument Type determines the type of difference calculation. If Type = 0 or if the argument is missing, the US method (NASD, National Association of Securities Dealers) is used. If Type <> 0, the European method is used.

Examples

DAYS360("1/1/2000";NOW()) returns the number of interest days from January 1, 2000 until today.