Days Between Dates Calculator
Find the exact number of calendar days, weeks, months, weekdays, and weekend days between any two dates.
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).