Skip to main content

How to Calculate Days Between Dates in Excel

Step-by-step guide to =DAYS(), =DATEDIF(), and =B2-A2 with an interactive formula tester.

MM/DD/YYYY

MM/DD/YYYY

Resulting Duration
43 days
1 month, 13 days · 6 weeks, 1 day
31 weekdays 12 weekend days
Weeks
6w 1d
Hours
1,032
Minutes
61,920
Seconds
3,715,200

3 Ways to Calculate Days Between Dates in Excel

1. Simple Subtraction (Fastest)

Assuming your start date is in A2 and your end date is in B2:

=B2 - A2

Format the result cell as General or Number (not Date).

2. The DAYS() Function (Excel 2013+)

=DAYS(B2, A2)

3. The DATEDIF() Function (For Years, Months, and Days)

=DATEDIF(A2, B2, "Y") & " years, " & DATEDIF(A2, B2, "YM") & " months, " & DATEDIF(A2, B2, "MD") & " days"