How to Calculate Days Between Dates (And Why You Keep Getting It Wrong)

Calculating the number of days between two dates sounds simple. Subtract one number from another and you are done. Except that dates are not simple numbers. They live in a calendar system built on irregular rules — months of varying lengths, leap years that arrive on a confusing schedule, and time zones that shift the starting line depending on where you stand.

If you have ever counted days on a calendar and gotten a different answer than your spreadsheet, you already know the problem. This article explains why date math is harder than it looks, the mistakes almost everyone makes, and how to get the right answer every time.

Why Date Math Is Harder Than It Looks

The Gregorian calendar is a compromise between astronomy and tradition. A solar year is approximately 365.2422 days long, which does not divide evenly into whole days. The calendar handles this with leap years, but the rule is more complex than “every four years.”

A year is a leap year if it is divisible by 4, unless it is divisible by 100, unless it is also divisible by 400. That means 2000 was a leap year, but 1900 was not, and 2100 will not be. If you are calculating days across a century boundary and you forget this rule, your count will be off by one day.

Month lengths add another layer. January has 31 days, February has 28 or 29, April has 30. There is no formula you can hold in your head. You either memorize the sequence or look it up, and a single mistake throws off the entire count.

Time zones complicate things further. “March 15” starts at a different moment in Tokyo than it does in New York. If your start and end dates are in different zones, the number of days between them depends on which zone you use as the reference. Most of the time this does not matter for whole-day counts, but it can cause off-by-one errors near midnight.

Common Mistakes People Make

Simple Subtraction

Subtracting the day numbers — the 15th minus the 1st — gives you 14, but the actual span from the 1st to the 15th is 15 days if you count both endpoints, or 14 days if you count the interval. The question “how many days between” usually means the interval, but not always. Contract language, legal deadlines, and cultural norms differ on whether the start day is included. This ambiguity is the single most common source of disagreement.

Ignoring Leap Years

If you calculate the days between January 1 and December 31 in a leap year, you get 365 days (the interval). In a non-leap year, you get 364. Forgetting to check whether February 29 falls inside your range is an easy mistake, especially when the range spans multiple years.

Timezone Issues

Consider a scenario where you start counting from March 10 at 11pm in New York, and end on March 12 at 2am in London. In New York time, the span crosses into March 11 and March 12, giving you two calendar days. In London time, the start is already March 11, and the end is March 12, giving you one calendar day. The difference is small, but for deadlines and contracts, one day matters.

Off-by-One Errors

This is the classic fencepost problem. If an event runs from Monday to Friday, is that five days or four? It depends on whether Friday is the last day of the event or the day after. Without a clear definition, two people can look at the same dates and get different answers.

How to Calculate Correctly

The reliable algorithm for calculating days between two dates works like this.

1. Convert both dates to a day count from a fixed epoch. The most common epoch is January 1, 1970 (the Unix epoch), but any fixed point works. The key is that the conversion accounts for leap years correctly.
2. Subtract the two day counts. This gives you the number of days in the interval, not counting the end date.
3. Adjust based on your definition. If you need to include the end date, add 1. If you need to include both endpoints, add 1. If you want the pure interval, leave it as is.

The conversion to a day count is where the leap year logic lives. A correct implementation checks the century rule (divisible by 100 but not 400 is not a leap year) and adds one day for each February 29 that falls within the range.

For most people, the practical approach is to use a tool that handles this correctly rather than implementing the algorithm by hand. A date calculator applies the rules consistently and removes the risk of a mental math error.

Practical Use Cases

Project Deadlines

If a project starts on July 7 and the contract allows 90 calendar days for delivery, the due date is October 5 — but only if you count correctly, including the possibility of a leap day if the range crosses February. Getting this wrong can mean missing a deadline or delivering early and surprising stakeholders.

Pregnancy Due Dates

Due dates are typically calculated as 280 days (40 weeks) from the last menstrual period. An off-by-one error here is clinically irrelevant, but an error in the month-length calculation could shift the date by several days, which matters for scheduling appointments and planning leave.

Contract Periods

Lease agreements, employment contracts, and service terms often specify durations in days. Whether a “30-day notice period” starts on the day you give notice or the day after is a legal question, but the calculation of what date is 30 days out is a math question. Getting it right avoids disputes.

Event Planning

Counting the days until an event determines when to send reminders, when to finalize headcounts, and when to start the final push. A wrong count means reminders go out at the wrong time or the final preparation phase is too short.

Using an Online Date Calculator

A dedicated date calculator handles the leap year rules, month lengths, and edge cases automatically. You enter a start date and an end date, and it returns the exact number of days, along with the breakdown in weeks and months if you need it.

TimeKit’s date calculator at /date-calculator does exactly this. You pick two dates, and it gives you the precise day count, accounting for all the calendar irregularities that make manual calculation error-prone. It also works in reverse: enter a start date and a number of days, and it tells you the end date, which is useful for deadline calculations.

For recurring calculations — like figuring out how many working days remain before a deadline, or how many calendar days are left in a quarter — a calculator saves time and eliminates the second-guessing that comes from doing it by hand.

A Quick Checklist for Date Calculations

Next time you need to calculate days between dates, run through these points.

• Have you defined whether the start date, end date, or both are included?
• Does the range cross February 29? If so, is the year a leap year?
• Does the range cross a century boundary (like 2100)? If so, check the 400-year rule.
• Are both dates in the same time zone? If not, decide which zone is the reference.
• Have you verified the result with a second method, like a calculator or a different spreadsheet formula?

Getting the count right is not hard once you know the rules. The problem is that most people never learn the rules, because date math seems like it should be simple. It is not. Treat it with the same care you would give to any calculation where being off by one has consequences, and use a reliable tool when the stakes are high.