What is the NETWORKDAYS Function
The NETWORKDAYS function counts the number of working days between two dates, excluding weekends and any holidays you specify. By default, Saturday and Sunday are treated as weekends.
Formula: =NETWORKDAYS(start_date, end_date, [holidays])
Practical Example 1
Start A2, End B2.
Type: =NETWORKDAYS(A2, B2)
Result: the count of working days between the dates
Practical Example 2
Exclude specific holidays listed in D2:D5.
Type: =NETWORKDAYS(A2, B2, D2:D5)
Result: working days excluding those holidays
Practical Example 3
Calculate working days for a project.
Type: =NETWORKDAYS(ProjectStart, ProjectEnd, Holidays)
Result: the actual working days for the project
When to Use It
NETWORKDAYS is used for project timelines, for leave calculations, for SLA tracking, for payroll processing, and for any calculation where you need the number of working days between two dates.