Days Between Dates: The Complete Date-Math Guide
How many days until the wedding? How many days between the contract start and today? How many weeks have you been training? Date math hides in every corner of life, and doing it mentally is a recipe for mistakes — especially with months of different lengths and leap years. This guide explains how date differences work, where they matter most, and how to get the exact answer in seconds.
How Date Difference Is Calculated
A date difference is the number of calendar days between two dates, including both the start and end days. The breakdown into years, months and days follows the same logic as age calculation: full years first, then complete months, then remaining days.
Our date difference calculator shows the calendar breakdown, total days and total weeks — everything at once.
Countdowns: Days Until a Big Event
Weddings, exams, trips, product launches — countdowns create anticipation and urgency. Put today as the start date and the event date as the end date, and you get the exact number of days remaining (and how many weeks that is).
Pregnancy Due Dates and Medical Dates
A pregnancy is counted from the first day of the last menstrual period, about 40 weeks or 280 days. Counting 280 days forward from that date gives the estimated due date. Date math is also used to track medication schedules, recovery windows and screening intervals.
Contracts, Deadlines and Legal Time Limits
Rental agreements, visa stays, warranty periods and payment deadlines all run on exact day counts. A 90-day visa is not 'about three months' — it is exactly 90 days, and the difference matters at the border.
Date Math in Excel and Google Sheets
- Excel: =DAYS(end, start) returns the day count; =DATEDIF(start, end, "D") works too
- Months: =DATEDIF(start, end, "M") gives complete months
- Years: =DATEDIF(start, end, "Y") gives complete years
- Google Sheets accepts the same formulas
- Our online calculator gives identical results without any software
Try the tool now
Enter your details and get the answer instantly — free and no sign-up.
Frequently Asked Questions
Count every calendar day between them, including both. Our date difference calculator does it instantly.
7. To convert days to weeks, divide by 7 — our calculator shows both.
Use today as the start date and the target date as the end date in our calculator.
Yes — the total counts every calendar day from the start date through the end date.