How to Calculate Days Between Two Dates
How to manually count the days between two dates, why calendar month lengths and leap years complicate it, and common real-world uses.
Counting days between two dates sounds simple until you hit a month boundary — months range from 28 to 31 days, and February adds a wrinkle in leap years, which is exactly why manual counting on a calendar is error-prone for anything more than a couple of weeks out.
The reliable method
Convert both dates to a single continuous day count (a "Julian-style" serial number, which is what date libraries and spreadsheet software use internally), then subtract. This sidesteps month-length and leap-year complications entirely, since you're working with a single linear number instead of calendar arithmetic.
Common real-world uses
- Contract and project deadlines — counting exactly how many days remain.
- Countdown to an event, trip, or milestone date.
- Calculating someone's exact age in days for a specific milestone.
- Determining how long an invoice, lease, or subscription period covers.
Inclusive vs. exclusive counting
Watch for whether a use case wants an "inclusive" count (both the start and end date counted) or the raw difference between two dates — a 5-night hotel stay, for example, spans 6 calendar dates but only 5 nights, a common source of off-by-one confusion.
The Date Calculator handles the full calculation automatically, including weeks, months, and a business-day count.