DAYS360 function

DAYS360(date1, date2, method?) DAYS360(date1; date2; method?)

date1 — Number or { Number }

The first date, as a sequential serial number.

date2 — Number or { Number }

The second date, as a sequential serial number.

method — Logical or { Logical } (optional)

FALSE to use the US NASD method and TRUE to use a European method. If omitted, FALSE is assumed.

Returns — Number or { Number }

The number of days between two dates, assuming a year with 360 days.

Returns the number of days between two dates. Unlike the DAYS function, this function is based on a year with 360 days (divided into twelve months, each containing 30 days).

Example

DAYS360(DATE(1981, 5, 1), DATE(2013, 1, 1))DAYS360(DATE(1981; 5; 1); DATE(2013; 1; 1))

Returns 11400, which is the number of days between May 1, 1981, and January 1, 2013, assuming a year with 360 days.