Date Difference Calculator: Days Between Two Dates
By TheToolsBank Editorial TeamLast updated:
Find exactly how many days are between two dates, with a full breakdown in years, months, weeks and days. For example, January 1 to December 31, 2026 is 364 days (365 if you count both ends). It also works as a days-past-due calculator: enter the due date and today's date to see how many days late a payment is.
How the Date Difference Calculator works
Pick a From date and a To date, then press Calculate. The calculator counts the exact number of days between them and also breaks that span down into a calendar-style years, months, and days figure — the same way you'd describe someone's age or a project's duration.
Inclusive vs. exclusive counting
By default, the calculator counts exclusively — the number of days you'd travel from the From date to reach the To date. Checking 'Include the To date in the count' adds one extra day, which matches how many contracts, notice periods, and legal deadlines are defined, where both the start and end date count as full days.
Counting business days only
Checking 'Show business days as the headline' switches the main result to count only Monday through Friday, skipping weekends — useful for estimating shipping times, processing periods, or any deadline defined in business days rather than calendar days.
Days Past Due Calculator
To find how many days an invoice or payment is past due, set the start date to the due date and the end date to today. The result is the number of days overdue. Use the Days past due button to fill today's date automatically. In Excel, use =TODAY()-A2, where A2 is the due date.Need to move a date forward or back instead? Use the Date Calculator to add days to a date, the Business Days Calculator to skip weekends, or the Age Calculator to work out someone's age.
Tracking unpaid invoices? See how to age accounts receivable.
Common Mistakes to Avoid
Assuming every date range is counted the same way
Solution:
Confusing calendar months with 30-day estimates
Solution:
Forgetting weekends when estimating business turnaround
Solution:
Not accounting for leap years
Solution:
Picking a From date after the To date
Solution:
Mixing up total hours with business hours
Solution:
The total hours figure is a simple 24-hour-per-day conversion of the full date range — it's not adjusted for business hours or working schedules.

