Kornilios Ampatzis/ May 2, 2019/ Functions

Calculates the number of days between two dates.

The syntax of the function is the following:

DAYS(end_date, start_date)

end_date: The end date of the period’s length in days we wish to calculate.
start_date: The start date of the period’s length in days we wish to calculate.

Click on the button to practice using this function, with the help of our Online Assessment Tool:

Practice

Here is an example of how to use the DAYS function:

Complete the cells C2:F2 following the instructions in the cells C1:F1.
C2: Subtract start date from enddate
D2: use the hidden datedif function to find the difference in days between the dates in A2:B2
E2,F2: use the functions shown in the first row to find the difference in days between the dates in A2:B2

Share this Post