DAYS function

DAYS(EndDate, StartDate) DAYS(EndDate; StartDate)

EndDate

Number or { Number }

The first date, as a sequential serial number.

StartDate

Number or { Number }

The second date, as a sequential serial number.

Returns

Number or { Number }

The number of days between two dates.

Returns the number of days between two dates.

Example

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

Returns 11568, which is the number of calendar days between May 1, 1981, and January 1, 2013.