How to Count Business Days Between Two Dates

All guides Calendars

Quick answer

Define which weekdays are working days, count eligible dates in the range, and skip any holiday dates from the calendar you are using.

Open Days Between Dates Calculator

Step by step

  1. Decide whether the start and end dates count. The example includes both endpoints if they are working days.
  2. Mark weekends under the schedule you use. For a Monday–Friday schedule, a complete seven-day block contributes five weekdays.
  3. Remove holidays only if they occur on counted workdays. In Google Sheets use =NETWORKDAYS(A2,B2,E2:E10) for a Saturday–Sunday weekend, with holiday dates in column E.

Worked examples

Monday through Friday

Nov 9–13, 2026 includes five weekdays on a Monday–Friday schedule. If Wednesday Nov 11 is on your holiday list, the count is four.

A weekend holiday

Extending the range through Sunday Nov 15 still gives four workdays. Listing Saturday Nov 14 as a holiday does not reduce the count again.

What to check

The Days Between Dates calculator shows all calendar days. Use a holiday list and a workweek definition when the task calls for business days.

Related guides

Sources

See the calculation methodology or report an error.