The Math Behind Calculating Days Between Two Dates

The Core Problem

Subtracting two dates is not as simple as subtracting two numbers, because the units are irregular: months have 28, 29, 30, or 31 days; years have 365 or 366 days; and the calendar itself was reformed in 1582, introducing a discontinuity in the date sequence. The standard mathematical solution is to convert each date to an absolute day count — a single integer representing the number of days since some fixed reference point — and then subtract the two counts.

Julian Day Numbers

Astronomers solved this problem in the 16th century by introducing the Julian Day Number (JDN) — not to be confused with the Julian calendar. The Julian Day Number is a continuous count of days since noon on January 1, 4713 BCE (in the Julian calendar), a date chosen by Joseph Scaliger in 1583 as a convenient origin point that predates all recorded history. January 1, 2000 has a JDN of 2,451,545.

The Julian Day Number is the standard used by astronomers for calculating intervals between celestial events and remains the cleanest way to handle date arithmetic in software.

The Algorithm: Gregorian Date to Julian Day Number

For a Gregorian calendar date (year Y, month M, day D), the Julian Day Number is:

a = ⌊(14 − M) / 12⌋
y = Y + 4800 − a
m = M + 12a − 3
JDN = D + ⌊(153m + 2) / 5⌋ + 365y + ⌊y/4⌋ − ⌊y/100⌋ + ⌊y/400⌋ − 32045

The terms handle the complexity of the calendar:

• The (14−M)/12 term shifts January and February to the end of the "previous" year (similar to Zeller's congruence), because the leap day in February affects the count for the whole year.
• The ⌊(153m + 2) / 5⌋ term converts month and day into a day-within-year count, accounting for the varying month lengths.
• The 365y + ⌊y/4⌋ − ⌊y/100⌋ + ⌊y/400⌋ terms add the total days from all complete years, with the three correction terms implementing the Gregorian leap year rule: every 4 years is a leap year, except every 100 years, except every 400 years.

Worked Example: January 1, 2000 to January 1, 2025

For January 1, 2000 (Y=2000, M=1, D=1):

• a = ⌊(14−1)/12⌋ = ⌊13/12⌋ = 1
• y = 2000 + 4800 − 1 = 6799
• m = 1 + 12×1 − 3 = 10
• ⌊(153×10 + 2)/5⌋ = ⌊1532/5⌋ = ⌊306.4⌋ = 306
• 365×6799 = 2,481,635
• ⌊6799/4⌋ = 1699; ⌊6799/100⌋ = 67; ⌊6799/400⌋ = 16
• JDN = 1 + 306 + 2,481,635 + 1699 − 67 + 16 − 32,045 = 2,451,545

This matches the known JDN for January 1, 2000.

For January 1, 2025 (Y=2025, M=1, D=1):

• a = 1, y = 6824, m = 10
• ⌊(153×10 + 2)/5⌋ = 306
• 365×6824 = 2,490,760
• ⌊6824/4⌋ = 1706; ⌊6824/100⌋ = 68; ⌊6824/400⌋ = 17
• JDN = 1 + 306 + 2,490,760 + 1706 − 68 + 17 − 32,045 = 2,460,677

Difference: 2,460,677 − 2,451,545 = 9,132 days

From January 1, 2000 to January 1, 2025 is exactly 9,132 days. We can verify: 25 years × 365 days = 9,125 days, plus 7 leap years (2000, 2004, 2008, 2012, 2016, 2020, 2024) = 9,125 + 7 = 9,132 days. Correct.

The Gregorian Reform of 1582 and Why It Complicates Everything

Before October 15, 1582, most of Europe used the Julian calendar, introduced by Julius Caesar in 46 BCE. The Julian calendar has a simple leap year rule: every year divisible by 4 is a leap year. This slightly overestimates the solar year (by about 11 minutes per year), causing a slow drift between the calendar and the seasons. By the 1500s, the drift had accumulated to 10 full days.

Pope Gregory XIII corrected this in 1582 by skipping 10 days: October 4, 1582 (Thursday) was followed directly by October 15, 1582 (Friday). He also modified the leap year rule: century years (1700, 1800, 1900) are not leap years unless divisible by 400 (so 2000 was a leap year, but 1900 was not). This is the Gregorian calendar still in use today.

The practical complication: if you try to calculate the days between, say, September 1, 1582 and November 1, 1582 using the Gregorian formula, you will get the wrong answer because those 10 missing days fall within the interval. The correct approach is to use the Julian Day Number formula for Julian calendar dates (which is slightly different) and the Gregorian formula for Gregorian dates.

Furthermore, different countries adopted the Gregorian calendar at different times: England and its colonies switched in 1752 (skipping 11 days by then), Russia in 1918, and Greece in 1923. When George Washington's birthday was changed from February 11 to February 22, 1731 (Julian) → 1732 (Gregorian), the date arithmetic reflects this colonial-era switch.

The Simpler Approach: Day-of-Year Counting

For dates within the same century (and especially the same year), a simpler method works:

1. Convert each date to its "day of year" — the ordinal position counting from January 1 = 1.
2. For multi-year spans, add 365 (or 366 for leap years) for each full year between the dates.
3. Subtract day-of-year of start from day-of-year of end, adjusted for year spans.

The cumulative day counts for the first day of each month in a non-leap year are well-known to programmers: January=1, February=32, March=60, April=91, May=121, June=152, July=182, August=213, September=244, October=274, November=305, December=335. In a leap year, add 1 to every month from March onward.

Calculate days between any two dates →