Days Between Dates in Google Sheets: Inclusive vs Exclusive Counting

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-A2 returns 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+1 returns 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-A2 would 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:

  1. Name the column after what it counts: “Nights”, “Calendar days (incl.)” or “Working days” instead of just “Days”.
  2. Add a note to the header cell (select it and press Shift + F2) saying whether the count includes both dates.

Related guides