How Many Days Between Dates: Manual, Excel & Online

Few tasks trip people up more than counting days between dates. Whether you are planning a project, tracking an anniversary, or just curious how long ago something happened, the answer often hides behind a mix of month lengths and leap years.

Excel DATEDIF unit “d”: Full days between dates · DAYS function introduced: Excel 2013 · Direct subtraction: Simplest Excel method

How to Calculate the Number of Days Between Two Dates

Manual calculation method

To manually find the days between two dates, subtract the earlier date from the later date by counting the days in each intervening month. For example, from March 15 to April 10: March has 31 days, so the remaining days in March are 16 (31 – 15), plus 10 days in April equals 26 days. You must account for leap years (February has 29 days in a leap year, 28 otherwise). The Gregorian calendar adds an extra day every four years, which shifts the calculation for dates crossing February 29.

Using an online date calculator

Online calculators like those at ablebits.com automate the entire process. Ablebits states that its online calculator shows how many days there are from one date to another after entering the two dates (Ablebits, spreadsheet solutions). You simply pick a start date and an end date, and the tool returns the total days, months, and years. Many also offer a business-days option that excludes weekends.

The implication: using two different methods (manual + online) lets you cross-check without extra work.

How Many Days Are Between Two Dates in Excel?

Using the DATEDIF function

Microsoft Support explains that the DATEDIF function with unit “d” returns the number of full days between two dates (Microsoft Support, Excel documentation). The syntax is =DATEDIF(start_date, end_date, "d"). Place the start date in one cell and the end date in another before applying the formula (Microsoft Support, Excel documentation).

Using a simple subtraction formula

The simplest Excel method, according to Ablebits, is to subtract the older date from the newer date (Ablebits, spreadsheet solutions). If cell A1 contains the start date and B1 the end date, =B1-A1 returns the number of days. Excel handles leap years and different month lengths automatically. For date-time values, combine INT with subtraction: =INT(B1-A1) isolates the day count (Ablebits, spreadsheet solutions).

The pattern: DATEDIF gives explicit control over units; direct subtraction is faster but less flexible.

How to Count Days Since a Past Event

Counting from a birthday or anniversary

To count days since a past event, subtract the past date from today’s date. In Excel, =TODAY()-A2 returns the number of days since the date in A2. For a precise count including the start day (if the event happened at midnight), add 1 to the result. Ablebits notes that the same subtraction logic applies in Google Sheets with the TODAY() function.

Counting from a historical event

For dates that cross centuries or calendar reforms, manual counting requires knowledge of historical calendar changes. The Gregorian calendar was adopted at different times in different countries, so results for events before the local adoption may be off by up to 10 days. Use a reputable online calculator that accounts for historical calendars.

What this means: for twentieth-century events onward, Excel and online tools are reliable. For older events, double-check with a historical calendar source.

What is the Best Date Between Two Dates Calculator?

Four popular date calculators, each with distinct strengths. The table below contrasts their core features.

Four tools, one pattern: automated results beat manual counting for speed, but you need the right tool for the job.

Why this matters: if you only need a raw day count, any tool works. But if you need to add or subtract days from a start date (e.g., “90 days from today”), calculator.net or Omnicalculator is better. For a countdown to a future event, timeanddate.com and Omnicalculator have dedicated views.

When to use a business day calculator

Business day calculators exclude weekends and optionally public holidays. Timeanddate.com’s duration calculator offers a “business days” option. This is essential for contract deadlines, shipping estimates, and project timelines. Ablebits’ online tool does not include a business-day mode.

The trade-off: simple day counters are free and fast; business-day tools require you to specify a holiday calendar and may only be accurate for the country you choose.

How Many Days Until a Future Date?

Using the “Countdown” feature

Online countdown tools display days, hours, minutes, and seconds until a target date. Timeanddate.com’s countdown calculator lets you set a future date and shows the time remaining. In Excel, =A1-TODAY() where A1 holds the future date gives the days until. For hours and minutes, combine with NOW().

Manual calculation for future dates

To manually compute days until a future date, subtract today’s date from the target date using the same month-borrowing method described earlier. Remember that a leap year adds a day if the target date is after February 29. For dates more than one year out, multiply years by 365 and add an extra day for each leap year in between.

The pattern: future-date calculations are identical in logic to past-event calculations—only the direction changes.

Steps: How to Calculate Days Between Dates Manually in 5 Steps

1. Write down both dates in the format YYYY-MM-DD (e.g., 2023-03-15 and 2023-04-10).
2. Subtract the year of the earlier date from the later date. If the later date’s month/day is earlier in the year, borrow 1 year (12 months) from the year difference.
3. Subtract the month of the earlier date from the later date. If the later day is smaller, borrow days from the previous month using that month’s number of days.
4. Subtract the day of the earlier date from the later date after borrowing. This gives the total days.
5. Add leap year adjustments: count how many February 29ths occurred between the two dates and add that many days.

For the example above: 2023-03-15 to 2023-04-10. Year difference = 0. Month difference = 1 (April – March). Day difference = 10 – 15? Borrow 1 month from April (30 days): +30 days, so day difference = (30 – 15) + 10 = 25. Total days = 0 years + 0 months + 25 days = 25 days. No leap day in that range, so result is 25 days.

Confirmed Facts vs. What’s Unclear

What Industry Experts Say

“The Date Duration Calculator on timeanddate.com calculates days, months, and years between two dates.”

— timeanddate.com, date/time authority

“This tool can add or subtract days from a given date, useful for planning.”

— calculator.net, online tools

Summary

Knowing how many days between dates is a core task for personal scheduling, professional deadlines, and even historical curiosity. The manual method teaches the logic; Excel formulas give you speed and repeatability; online calculators catch mistakes. For the average user working with modern dates, a combination of direct subtraction in a spreadsheet and a quick sanity check with an online tool is the most efficient workflow. For anyone tracking contract timelines or project milestones, the choice is clear: use a business-day calculator that accounts for weekends and holidays, or your deadline could slip by.