This function will allow you to find the number of days between two dates.

Syntax

DAYS(Start Date, End Date)

  • Start Date (required) – This is the starting date of the period.
  • End Date (required) – This is the ending date of the period.

Example

In this example we find the number of days between two dates. Notice that if the end date is older than the start date the result is a negative number. The same result can be obtained by subtracting the start date from the end date.

=DAYS(A2,B2)

DAYS DAYS function