Skip to main content
πŸ‡ΊπŸ‡Έ United States · MM/DD/YYYY

Days Between Dates Calculator

Find the exact number of calendar days, weeks, months, weekdays, and weekend days between any two dates.

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

How Days Between Dates Are Counted

By default, counting days between two dates measures the elapsed interval (End Date βˆ’ Start Date). For example, from Monday, November 16 to Tuesday, November 17 is 1 day. If you need an inclusive count (such as counting both the first and last day of a 5-day conference), check Include End Date (+1 day).

Excel & Google Sheets Equivalent

In Excel or Google Sheets, use =DAYS(B2, A2) or =B2 - A2 formatted as a number. Need to exclude weekends and US federal holidays? Switch to our US Business Days Calculator.

Frequently Asked Questions

Should I include the end date when counting days between dates?

For elapsed duration (like hotel nights or age), leave "Include End Date" unchecked. For inclusive spans (like a 5-day conference from Monday to Friday), check "Include End Date".

How do I calculate days between dates in Excel?

Use simple subtraction (=B2-A2) formatted as a Number, or use =DAYS(B2, A2). For working days only, use =NETWORKDAYS(A2, B2).