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:
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