StatGardenREF. DESK
Calculators/Date & time/Days between dates
Date & time

Days between dates calculator

Elapsed time between two dates, with and without weekends.

What this calculator does

Days between dates works out elapsed time between two dates, with and without weekends. Enter your own figures above and the answer updates as you type: nothing is fixed in the code, so the result reflects exactly the numbers you supply.

The formula this calculator evaluates is printed under the tool and explained below, so you can check the working by hand or reuse it in a spreadsheet.

The formula

FormulaDays = (date₂ − date₁)/86,400,000 ms; business days exclude Saturdays and Sundays

The inputs explained

FieldWhat to enter
Start dateA calendar date.
End dateA calendar date.

Worked examples

Every figure in the tables below is produced by this page’s own calculator at build time, so the numbers and the tool always agree. Select any row to load that scenario.

Examples across different dates

The same calculation at a range of dates, with every other input held at its starting value. These are generated relative to the day the page was built.

Examples across different dates
End dateDaysWeeksMonths (approx.)
2026-08-1171.000.23
2026-09-03304.290.99
2026-11-029012.862.96
2027-01-3118025.715.91
2027-08-0436552.1411.99