Uploaded July 2023 | Updated September 2026, 2 weeks ago

---

How to calculate the number of days between two dates in Excel | How to calculate the number of days in Excel including start and end date

To find the number of days between these two dates,
1. Using Subtraction
you can enter “=end date cell - beginning date cell”
Once you hit enter, Excel will automatically calculate the days between the two dates entered.

2. Using the “DAYS” function
The DAYS function returns the number of days between two dates.
= DAYS(end_date, start_date)
This will also give you the same answer, the number of days between those dates.

0:00 Intro
0:10 Using Subtraction
0:53 Using the “DAYS” function

Microsoft Excel