DAYS360 function

DAYS360 returns the difference between two dates based on the 360-day year that is used in interest calculations. The result is an integer.

Syntax

DAYS360(date_1, date_2, type)

  • date_1 is the start date.
  • date_2 is the end date.

If date_2 is earlier than date_1, the function returns 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.

Example

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