DAYS function

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

EndDate

Temporal Temporal

The date at the end of the period.

Temporal Temporal

The date at the start of the period.

Number Number

The number of days between two dates.

Returns the number of days between two dates. The result is negative if the end date is earlier than the start date.

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.

DAYS ( DATE (2013, 1, 1), DATE (2013, 1, 11))

DAYS ( DATE (2013; 1; 1); DATE (2013; 1; 11))

Returns -10, as the end date is ten days earlier than the start date.