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.