Sheetsdrill

Dates Updated November 2026

NETWORKDAYS

NETWORKDAYS(start_date, end_date, [holidays]) counts the days between two dates inclusive, skipping Saturdays, Sundays and any dates in the optional holidays range. NETWORKDAYS.INTL adds a weekend argument for other rest days, and WORKDAY goes the other way, returning the date a number of working days later.

Syntax

=NETWORKDAYS(start_date, end_date, [holidays]) and =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
PartWhat it is
start_dateThe first day, counted if it is a working day.
end_dateThe last day, also counted.
holidaysOptional range of dates to exclude, for example Holidays!A2:A20.
weekendNETWORKDAYS.INTL only: a number (1 = Sat/Sun, 7 = Fri/Sat) or a 7-character string of 0 and 1 starting Monday, where 1 means a rest day.

Examples

=NETWORKDAYS(DATE(2026,11,2), DATE(2026,11,13))

Result: 10

Two full Monday-to-Friday weeks.

=NETWORKDAYS(DATE(2026,11,2), DATE(2026,11,13), DATE(2026,11,11))

Result: 9

November 11 is excluded as a holiday.

=NETWORKDAYS(DATE(2026,12,1), DATE(2026,12,31), Holidays!A2:A10)

Result: 22 when the holiday list contains December 25, 2026 (23 without it)

Common mistakes

  • The count includes both the start and end dates, so Monday to Friday of the same week is 5, not 4.
  • Holidays typed as text are ignored; the holiday range must contain real dates.
  • A negative result means start_date is after end_date.

Practice NETWORKDAYS

These drills check your answer on live data, free, no account needed.

  • Working days with holidaysCount the working days (Monday to Friday) from start to due date, both included, leaving out the holidays in F2:F4. Fill D2 and D3 using NETWORKDAYS.

Questions

How do I add 10 working days to a date?

=WORKDAY(A2, 10, Holidays!A:A) returns the date ten working days after A2.

How do I count working days in a month?

=NETWORKDAYS(DATE(2026,12,1), EOMONTH(DATE(2026,12,1), 0), Holidays!A:A).

Related

  • TODAY and NOWHow TODAY and NOW in Google Sheets return the current date and time, how to calculate days until a deadline, age and overdue flags, and why the value changes.
  • EOMONTH and EDATEHow EOMONTH and EDATE in Google Sheets return the last day of a month or the same day N months later, with examples for due dates and first of month.
  • DATEDIFHow DATEDIF in Google Sheets returns whole years, months or days between two dates, with the unit codes, examples for age and tenure, and common errors.
  • DATE, YEAR, MONTH and DAYHow DATE, YEAR, MONTH and DAY work in Google Sheets to build a date from parts, pull the year or month out of a date, group by month and fix text dates.

Previous: EOMONTH and EDATENext: DATE, YEAR, MONTH and DAY