How to Calculate Date Differences: Days Between Dates Guide

Published February 11, 2026 · 7 min read

Whether you're counting down to a vacation, calculating project timelines, tracking pregnancy milestones, or figuring out how many business days until a deadline, knowing how to calculate the difference between two dates is a surprisingly common need. This guide covers the math, the methods, and the practical tools you can use.

The Basic Formula

At its simplest, calculating the number of days between two dates is straightforward subtraction. In most programming languages and spreadsheets, dates are stored as numbers (days since a reference point), making subtraction trivial.

In JavaScript

const start = new Date('2026-01-01');
const end = new Date('2026-12-31');
const diffMs = end - start;
const diffDays = Math.round(diffMs / 86400000);
// Result: 364 days

The key number is 86,400,000 — the number of milliseconds in a day (24 × 60 × 60 × 1000).

In Excel / Google Sheets

Simply subtract one date cell from another: =B1-A1 gives you the number of days. For a more detailed breakdown, use the DATEDIF function:

=DATEDIF(A1, B1, "Y")  → Years
=DATEDIF(A1, B1, "M")  → Months
=DATEDIF(A1, B1, "D")  → Days

Calculating Years, Months, and Days

Simple subtraction gives you the total number of days, but breaking that into years, months, and days requires more care because months have different lengths (28-31 days) and leap years add an extra day in February.

The algorithm works like this:

1. Calculate the difference in years between the two dates
2. Calculate the remaining months
3. Calculate the remaining days
4. If the day difference is negative, borrow a month and add the appropriate number of days
5. If the month difference is negative, borrow a year and add 12 months

For example, the difference between January 15, 2026 and March 10, 2026 is 1 month and 23 days (or 54 total days).

Business Days vs Calendar Days

In many professional contexts, you need to count only business days (weekdays), excluding Saturdays and Sundays. Some calculations also exclude public holidays.

Counting Business Days

To count business days between two dates:

1. Loop through each day in the range
2. Check if the day is a weekday (Monday through Friday)
3. If yes, increment the counter

In Excel, use the NETWORKDAYS function: =NETWORKDAYS(A1, B1). This automatically excludes weekends and can optionally exclude holidays.

Common Use Cases

Project Management

Project managers constantly calculate date differences for sprint planning, milestone tracking, and deadline estimation. Knowing that a 3-month project starting March 1st ends May 31st (92 days, ~66 business days) helps with resource allocation and scheduling.

Age Calculation

Calculating someone's exact age is a date difference problem. The Age Calculator on Wootils handles this automatically, showing years, months, and days since birth.

Pregnancy Tracking

Pregnancy is typically measured as 40 weeks (280 days) from the last menstrual period. The Due Date Calculator uses date arithmetic to estimate delivery dates and show trimester milestones.

Financial Calculations

Interest calculations often depend on the exact number of days in a period. The "actual/365" day count convention divides actual days by 365 to get the year fraction. This is crucial for bond pricing, loan interest, and investment returns. Try the Compound Interest Calculator to see how time periods affect your returns.

Legal and Contract Deadlines

Legal deadlines are often specified in calendar days or business days. "30 calendar days" and "30 business days" can differ by two weeks — a distinction that matters in contracts, notices, and regulatory compliance.

Handling Edge Cases

Leap Years

A year is a leap year if it's divisible by 4, except for century years, which must be divisible by 400. So 2024 and 2028 are leap years, but 2100 is not. This means February can have 28 or 29 days, affecting calculations that span multiple years.

Daylight Saving Time

When calculating date differences using timestamps (milliseconds), DST transitions can cause the difference to be off by an hour. Using Math.round() instead of Math.floor() when dividing by 86,400,000 handles this edge case.

Time Zones

If your dates include time zone information, make sure both dates use the same time zone before calculating. The Timestamp Converter can help you normalize dates to UTC.

Date Difference in Different Languages

Quick Reference: Days in Each Month

Conclusion

Date difference calculations are everywhere — from project planning to financial modeling to everyday curiosity ("how many days until my birthday?"). While the basic math is simple subtraction, edge cases like leap years, varying month lengths, and business day exclusions add complexity.

For quick calculations, use the Date Difference Calculator on Wootils. For calculations in code, most languages have built-in date libraries that handle the complexity for you.

← Back to blog