NETWORKDAYS

Counts the number of working days between two dates, excluding weekends and an optional list of holidays. Essential for SLA tracking, project scheduling, and deadline calculations.

Syntax

excel-mastery

=NETWORKDAYS(start_date, end_date, [holidays])

Example

excel-mastery

=NETWORKDAYS(B2, C2, HolidayTable[Date])

=NETWORKDAYS(OrderDate, TODAY(), Holidays)

=WORKDAY(StartDate, 10, Holidays)