Counting Days Between Dates
Why calculators disagree by one, and which count you need.
The Short Answer
Most calculators report elapsed days: end date minus start date. Monday to Friday is 4.
If you need to count both the first and last day, as you would for a five-day work week, an event, or days of leave, add one. Monday to Friday is 5 inclusive.
Count days between two dates →Why Calculators Disagree by Exactly One
It's the fence-post problem. A fence 4 metres long with a post every metre needs 5 posts. The gaps are the elapsed count; the posts are the inclusive count.
| Dates | Elapsed | Inclusive |
|---|---|---|
| Mon 5 Oct → Fri 9 Oct | 4 | 5 |
| 1 Mar → 31 Mar | 30 | 31 |
| Same day to same day | 0 | 1 |
When two tools disagree by one, check which of these each is reporting before assuming either is wrong.
Which Count Do You Need?
| Question | Count |
|---|---|
| How long until my deadline? | Elapsed |
| How many nights is this hotel stay? | Elapsed (nights) |
| How many days of leave am I taking, Monday to Friday? | Inclusive |
| How many days does this conference run? | Inclusive |
| How old is this, in days? | Elapsed |
Days Versus Nights
A stay that checks in Monday and out Friday is four nights across five calendar days. Hotels bill nights, which matches the elapsed count. Car hire and parking are usually billed by 24-hour periods from pick-up time, so an extra hour on the return can add a whole day.
Deadlines: "Within 30 Days"
Legal and contractual deadlines have their own counting rules, and they're worth checking rather than guessing. A widely used convention, found for example in the US federal court rules, works like this:
- Exclude the day of the event that starts the clock.
- Count every day after it, including weekends and holidays.
- Include the last day, but if it falls on a weekend or holiday, the deadline moves to the next working day.
Contracts, courts in other countries and government agencies can define it differently. When the stakes are real, the wording of the rule that applies to you beats any calculator.
The Daylight-Saving Trap
A subtler cause of off-by-one answers: the day the clocks go forward is only 23 hours long. A calculator that works out the difference in hours, divides by 24 and rounds down will come up a day short across that change. We tested this: 1 to 31 March 2026 in US Eastern time works out to 29.96 days, which rounds down to 29 when the right answer is 30.
The Date Difference calculator rounds to the nearest whole day, so it handles clock changes correctly. It reports elapsed days, the same as subtracting the dates; add one for an inclusive count.
In a Spreadsheet
Spreadsheets behave the same way. In Excel or Google Sheets, =B1-A1 gives elapsed days and =B1-A1+1 gives the inclusive count. NETWORKDAYS is the exception: it counts working days including both the start and end dates, so it can look one higher than you'd expect from a plain subtraction.
Frequently Asked Questions
How many days are there between Monday and Friday?
Four days elapse from Monday to Friday, which is what most calculators report. But Monday to Friday covers five days if you count both of them, as you would for a five-day work week or a five-day event. Neither count is wrong; they answer different questions.
How do I count days inclusively?
Take the ordinary difference between the two dates and add one. Monday to Friday is 4 days of difference, so 5 days inclusive. If the start and end are the same date, the inclusive count is 1.
Why do two date calculators give answers one day apart?
One is counting elapsed days and the other is counting both endpoints. A smaller cause is daylight saving time: a calculator that divides by exactly 24 hours and rounds down can come out one day short across the spring clock change.
Is a hotel stay counted in days or nights?
Nights. Checking in Monday and out Friday is four nights, which matches the elapsed count, while the stay touches five calendar days. Car rental and parking are usually billed by 24-hour periods instead, which can differ again.
How is a deadline like within 30 days counted?
It depends on the rules that apply, so check them. A common legal convention, used for example in US federal court rules, excludes the day of the triggering event, counts every day after it including weekends, and includes the last day, moving on to the next business day if the last day falls on a weekend or holiday. Contracts can define it differently.
Does the calculator on this site include the end date?
It reports elapsed days, the difference from the start date to the end date, so the start day itself is not counted. For an inclusive count, add one to the result.