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"