Subtracting two dates in Google Sheets gives an exclusive count: =B2-A2 returns 4 for Monday to Friday of the same week. If you want to count every day including both the first and the last, use =B2-A2+1, which returns 5. This guide shows how to decide which one you need, because the wrong choice is one of the most common off-by-one errors in spreadsheets.
Tested in Google Sheets. On November 9, 2026 we entered the formulas on this page in Google Sheets, every row of the summary table, including the same-day case, and compared the results with values calculated independently. How we test
Why subtraction is “one short”
Think of dates as fence posts. From Monday to Friday there are five posts but only four gaps between them. Subtraction counts the gaps: the number of days you move forward to get from the start date to the end date.
| Mon | Tue | Wed | Thu | Fri | |
|---|---|---|---|---|---|
| Days counted inclusively | 1 | 2 | 3 | 4 | 5 |
| Steps forward from Monday | 0 | 1 | 2 | 3 | 4 |
Both answers are correct. They answer different questions.
Exclusive count: =B2-A2
Use the plain subtraction when you are measuring elapsed time or nights:
- Hotel stays. Check-in Monday, July 6, 2026, check-out Friday, July 10, 2026:
=B2-A2returns 4 nights. - Time since an event. Days since an order was placed, since a ticket was opened or since a last purchase.
- Days until a deadline.
=B2-TODAY()returns 0 on the deadline day itself, which is usually what you want.
Inclusive count: =B2-A2+1
Add 1 when both the first and the last day are days that “count”:
- Leave or holiday requests. Away from Monday, August 3 to Friday, August 14, 2026:
=B2-A2+1returns 12 calendar days. - Rentals charged per day. A car rented and returned on the same day is usually one day, not zero.
- Project or event duration. A project running from September 1 to September 30, 2026 lasts 30 days (
=B2-A2would say 29).
Same-day check: if the start and end date are the same, the exclusive count is 0 and the inclusive count is 1. This is a quick way to test which formula your sheet is using.
Working days are already inclusive
NETWORKDAYS counts the start date and the end date when they are weekdays, so do not add 1:
=NETWORKDAYS(A2, B2)
For the leave example above (August 3 to August 14, 2026), NETWORKDAYS returns 10 working days. Adding 1 would wrongly give 11.
The exception is when you want the working days after the start date, for example business days to process an order received on Monday. In that case, subtract 1 if the start date is itself a working day, or start counting from the next day: =NETWORKDAYS(A2+1, B2).
Summary table
| Start | End | Exclusive =B-A |
Inclusive =B-A+1 |
Working days NETWORKDAYS |
|---|---|---|---|---|
| Mon, Jul 6, 2026 | Fri, Jul 10, 2026 | 4 | 5 | 5 |
| Mon, Aug 3, 2026 | Fri, Aug 14, 2026 | 11 | 12 | 10 |
| Tue, Sep 1, 2026 | Wed, Sep 30, 2026 | 29 | 30 | 22 |
| Wed, Apr 1, 2026 | Wed, Apr 1, 2026 | 0 | 1 | 1 |
Make the choice visible in your sheet
Off-by-one errors are hard to spot later. Two simple habits help:
- Name the column after what it counts: “Nights”, “Calendar days (incl.)” or “Working days” instead of just “Days”.
- Add a note to the header cell (select it and press Shift + F2) saying whether the count includes both dates.