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.