Introduction
The NETWORKDAYS function in Excel calculates the number of working days between two dates. It automatically excludes Saturdays and Sundays and can also exclude specified holidays. This function is useful for employee attendance, payroll calculations, project planning, and business working-day reports.
What Is the NETWORKDAYS Function in Excel?
The NETWORKDAYS function counts the working days between a starting date and an ending date.
By default, Excel considers:
- Monday to Friday as working days.
- Saturday and Sunday as weekends.
- Dates listed in a holiday range as non-working days.
For example, suppose an employee works from 1-Jan-2026 to 7-Jan-2026.
The period contains seven calendar days, but Saturday and Sunday are excluded. Therefore, NETWORKDAYS returns 5 working days.
NETWORKDAYS Function Syntax
=NETWORKDAYS(start_date,end_date,[holidays])
Understanding the Arguments
| Argument | Meaning |
|---|---|
| start_date | The starting date of the period. |
| end_date | The ending date of the period. |
| holidays | Optional dates that should also be excluded from working days. |
Important: Both the starting date and ending date are included in the calculation if they are working days.
How Does NETWORKDAYS Work?
NETWORKDAYS checks every date between the starting and ending dates.
It counts a date if it is a normal working day and does not appear in the holiday list.
Let’s understand this with an example.
Suppose:
- Starting Date: 05-Jan-2026 (Monday)
- Ending Date: 11-Jan-2026 (Sunday)
| Date | Day | Counted as Working Day? |
|---|---|---|
| 05-Jan-2026 | Monday | Yes |
| 06-Jan-2026 | Tuesday | Yes |
| 07-Jan-2026 | Wednesday | Yes |
| 08-Jan-2026 | Thursday | Yes |
| 09-Jan-2026 | Friday | Yes |
| 10-Jan-2026 | Saturday | No |
| 11-Jan-2026 | Sunday | No |
Expected Result: 5 Working Days
Excel counts Monday to Friday and automatically excludes Saturday and Sunday.
Understanding the Holidays Argument
The third argument is optional. It allows you to exclude additional dates, such as public holidays or company holidays.
Suppose your holiday list is stored in cells F2.
| Holiday Date | Holiday Name |
|---|---|
| 07-Jan-2026 | Company Holiday |
| 09-Jan-2026 | Public Holiday |
Formula:
=NETWORKDAYS(A2,B2,F2:F3)
Expected Result: 3
The original working-day count is 5. Excel excludes two additional holidays, so the result becomes 3.
Remember: The holiday list should contain valid Excel dates, not just text that looks like dates.
Practical Examples of NETWORKDAYS Function in Excel
Question 1: Calculate Working Days Between Two Dates
Problem Statement:
An HR department wants to calculate the number of working days between employee joining dates and a fixed reporting date.
Employee Data:
| Employee Name | Joining Date | Reporting Date |
|---|---|---|
| Rahul | 05-Jan-2026 | 11-Jan-2026 |
| Priya | 12-Jan-2026 | 18-Jan-2026 |
| Amit | 19-Jan-2026 | 25-Jan-2026 |
| Neha | 26-Jan-2026 | 01-Feb-2026 |
Excel Formula:
Enter this formula in D2:
=NETWORKDAYS(B2,C2)
Expected Result:
| Employee Name | Joining Date | Reporting Date | Working Days |
|---|---|---|---|
| Rahul | 05-Jan-2026 | 11-Jan-2026 | 5 |
| Priya | 12-Jan-2026 | 18-Jan-2026 | 5 |
| Amit | 19-Jan-2026 | 25-Jan-2026 | 5 |
| Neha | 26-Jan-2026 | 01-Feb-2026 | 5 |
Explanation:
The formula checks the dates in B2 and C2.
Excel counts Monday to Friday and excludes Saturday and Sunday. Both starting and ending dates are included when they fall on working days.
For Rahul, the period from Monday, 5 January, to Sunday, 11 January, contains five working days.
Concept Covered: Calculating working days without a holiday list.
Question 2: Calculate Working Days After Excluding Holidays
Problem Statement:
A company wants to calculate working days while excluding its official holidays.
Project Data:
| Project Name | Start Date | End Date |
|---|---|---|
| Website Development | 05-Jan-2026 | 11-Jan-2026 |
| Mobile Application | 12-Jan-2026 | 18-Jan-2026 |
| Database Setup | 19-Jan-2026 | 25-Jan-2026 |
Holiday List:
Enter the following holiday dates in F2.
| Holiday Date | Holiday Name |
|---|---|
| 07-Jan-2026 | Company Holiday |
| 13-Jan-2026 | Public Holiday |
| 21-Jan-2026 | Company Holiday |
Excel Formula:
Enter this formula in D2:
=NETWORKDAYS(B2,C2,$F$2:$F$4)
Expected Result:
| Project Name | Start Date | End Date | Working Days |
|---|---|---|---|
| Website Development | 05-Jan-2026 | 11-Jan-2026 | 4 |
| Mobile Application | 12-Jan-2026 | 18-Jan-2026 | 4 |
| Database Setup | 19-Jan-2026 | 25-Jan-2026 | 4 |
Explanation:
The formula calculates the normal working days and then excludes the dates listed in F2.
For Website Development, the normal working-day count is 5. Since 7 January is a holiday, Excel returns 4.
The dollar signs in $F$2:$F$4 keep the holiday range fixed when you copy the formula down.
Concept Covered: Excluding multiple holidays from working-day calculations.
Question 3: Calculate Employee Attendance Days
Problem Statement:
An HR department wants to calculate the number of working days between an employee’s attendance period.
Attendance Data:
| Employee Name | Attendance Start | Attendance End |
|---|---|---|
| Aman | 02-Feb-2026 | 06-Feb-2026 |
| Riya | 09-Feb-2026 | 13-Feb-2026 |
| Karan | 16-Feb-2026 | 20-Feb-2026 |
| Simran | 23-Feb-2026 | 27-Feb-2026 |
Excel Formula:
Enter this formula in D2:
=NETWORKDAYS(B2,C2)
Expected Result:
| Employee Name | Attendance Start | Attendance End | Working Days |
|---|---|---|---|
| Aman | 02-Feb-2026 | 06-Feb-2026 | 5 |
| Riya | 09-Feb-2026 | 13-Feb-2026 | 5 |
| Karan | 16-Feb-2026 | 20-Feb-2026 | 5 |
| Simran | 23-Feb-2026 | 27-Feb-2026 | 5 |
Explanation:
Each attendance period starts on Monday and ends on Friday.
NETWORKDAYS counts all five weekdays in each period.
Concept Covered: Counting weekdays in employee attendance periods.
Question 4: Calculate Project Working Days with Multiple Holidays
Problem Statement:
A project manager wants to calculate the actual working days available for different projects after excluding company holidays.
Project Data:
| Project Name | Start Date | End Date |
|---|---|---|
| Project A | 02-Mar-2026 | 13-Mar-2026 |
| Project B | 16-Mar-2026 | 27-Mar-2026 |
| Project C | 30-Mar-2026 | 10-Apr-2026 |
Company Holiday List:
Enter these dates in F2.
| Holiday Date | Holiday Name |
|---|---|
| 05-Mar-2026 | Company Holiday |
| 18-Mar-2026 | Public Holiday |
| 06-Apr-2026 | Company Holiday |
Excel Formula:
Enter this formula in D2:
=NETWORKDAYS(B2,C2,$F$2:$F$4)
Expected Result:
| Project Name | Start Date | End Date | Working Days |
|---|---|---|---|
| Project A | 02-Mar-2026 | 13-Mar-2026 | 9 |
| Project B | 16-Mar-2026 | 27-Mar-2026 | 9 |
| Project C | 30-Mar-2026 | 10-Apr-2026 | 9 |
Explanation:
Each project period contains ten weekdays. Excel excludes one company holiday from each period, so the result is nine working days.
Concept Covered: Calculating project working days after excluding holidays.
Question 5: Calculate Working Days for a Monthly Report
Problem Statement:
A sales manager wants to calculate the working days in different monthly reporting periods.
Monthly Report Data:
| Report Month | Start Date | End Date |
|---|---|---|
| January | 01-Jan-2026 | 31-Jan-2026 |
| February | 01-Feb-2026 | 28-Feb-2026 |
| March | 01-Mar-2026 | 31-Mar-2026 |
| April | 01-Apr-2026 | 30-Apr-2026 |
Excel Formula:
Enter this formula in D2:
=NETWORKDAYS(B2,C2)
Expected Result:
| Report Month | Start Date | End Date | Working Days |
|---|---|---|---|
| January | 01-Jan-2026 | 31-Jan-2026 | 22 |
| February | 01-Feb-2026 | 28-Feb-2026 | 20 |
| March | 01-Mar-2026 | 31-Mar-2026 | 22 |
| April | 01-Apr-2026 | 30-Apr-2026 | 22 |
Explanation:
The formula counts Monday to Friday for the complete month.
For January 2026, there are 22 weekdays. NETWORKDAYS returns 22 because no holiday list has been provided.
Concept Covered: Calculating monthly working days.
Question 6: Calculate Working Days for a Payment Period
Problem Statement:
An accounts department wants to calculate the number of working days between an invoice date and its payment date.
Payment Data:
| Invoice Number | Invoice Date | Payment Date |
|---|---|---|
| INV101 | 02-Mar-2026 | 06-Mar-2026 |
| INV102 | 09-Mar-2026 | 13-Mar-2026 |
| INV103 | 16-Mar-2026 | 20-Mar-2026 |
| INV104 | 23-Mar-2026 | 27-Mar-2026 |
Excel Formula:
Enter this formula in D2:
=NETWORKDAYS(B2,C2)
Expected Result:
| Invoice Number | Invoice Date | Payment Date | Working Days |
|---|---|---|---|
| INV101 | 02-Mar-2026 | 06-Mar-2026 | 5 |
| INV102 | 09-Mar-2026 | 13-Mar-2026 | 5 |
| INV103 | 16-Mar-2026 | 20-Mar-2026 | 5 |
| INV104 | 23-Mar-2026 | 27-Mar-2026 | 5 |
Explanation:
The formula calculates the number of working days between the invoice date and payment date.
For INV101, the period starts on Monday and ends on Friday. Therefore, Excel returns five working days.
Concept Covered: Calculating business days between invoice and payment dates.
Question 7: Calculate Working Days Using Cell References for Holidays
Problem Statement:
A company maintains a holiday list in a separate section of its worksheet. The HR team wants to calculate employee working days using the holiday dates stored in that list.
Employee Data:
| Employee Name | Start Date | End Date |
|---|---|---|
| Rahul | 06-Apr-2026 | 10-Apr-2026 |
| Priya | 13-Apr-2026 | 17-Apr-2026 |
| Amit | 20-Apr-2026 | 24-Apr-2026 |
| Neha | 27-Apr-2026 | 01-May-2026 |
Holiday List:
Enter the following dates in F2.
| Holiday Date | Holiday Name |
|---|---|
| 07-Apr-2026 | Company Holiday |
| 15-Apr-2026 | Public Holiday |
| 30-Apr-2026 | Company Holiday |
Excel Formula:
Enter this formula in D2:
=NETWORKDAYS(B2,C2,$F$2:$F$4)
Expected Result:
| Employee Name | Start Date | End Date | Working Days |
|---|---|---|---|
| Rahul | 06-Apr-2026 | 10-Apr-2026 | 4 |
| Priya | 13-Apr-2026 | 17-Apr-2026 | 4 |
| Amit | 20-Apr-2026 | 24-Apr-2026 | 5 |
| Neha | 27-Apr-2026 | 01-May-2026 | 4 |
Explanation:
The formula checks each employee’s date range and excludes any holiday that falls within that range.
For Rahul, the normal count is five weekdays. Since 7 April is included in the holiday list, Excel returns four.
For Amit, none of the listed holidays falls within the date range, so the result remains five.
Concept Covered: Using an absolute cell reference for a reusable holiday list.
Student Practice Tasks
Try solving these tasks using only the NETWORKDAYS function.
Task 1: Calculate Employee Working Days
| Employee | Start Date | End Date |
|---|---|---|
| Mohit | 04-May-2026 | 08-May-2026 |
| Sneha | 11-May-2026 | 15-May-2026 |
| Varun | 18-May-2026 | 22-May-2026 |
Calculate the working days for each employee.
Task 2: Exclude Company Holidays
Employee Data:
| Employee | Start Date | End Date |
|---|---|---|
| Employee A | 01-Jun-2026 | 05-Jun-2026 |
| Employee B | 08-Jun-2026 | 12-Jun-2026 |
| Employee C | 15-Jun-2026 | 19-Jun-2026 |
Holiday List:
| Holiday Date | Holiday Name |
|---|---|
| 03-Jun-2026 | Company Holiday |
| 10-Jun-2026 | Public Holiday |
| 17-Jun-2026 | Company Holiday |
Calculate working days after excluding the holiday dates.
Task 3: Calculate Project Working Days
| Project | Start Date | End Date |
|---|---|---|
| Project X | 06-Jul-2026 | 17-Jul-2026 |
| Project Y | 20-Jul-2026 | 31-Jul-2026 |
| Project Z | 03-Aug-2026 | 14-Aug-2026 |
Calculate the total working days for each project.
Final Student Challenge: Build an Employee Working Days Report
Problem Statement:
You are working in the HR department. Your manager wants a report showing the working days for each employee after excluding company holidays.
Use the following employee data.
Employee Data:
| Employee Name | Start Date | End Date |
|---|---|---|
| Rahul | 03-Aug-2026 | 14-Aug-2026 |
| Priya | 17-Aug-2026 | 28-Aug-2026 |
| Amit | 31-Aug-2026 | 11-Sep-2026 |
| Neha | 14-Sep-2026 | 25-Sep-2026 |
Company Holiday List:
Enter these dates in F2.
| Holiday Date | Holiday Name |
|---|---|
| 05-Aug-2026 | Company Holiday |
| 20-Aug-2026 | Public Holiday |
| 04-Sep-2026 | Company Holiday |
| 18-Sep-2026 | Public Holiday |
Your Tasks:
- Calculate working days for each employee.
- Exclude Saturdays and Sundays automatically.
- Exclude all company holidays that fall within the employee’s date range.
- Use an absolute reference for the holiday range.
- Copy the formula for all employees.
Expected Report Structure:
| Employee Name | Start Date | End Date | Working Days |
|---|---|---|---|
| Rahul | 03-Aug-2026 | 14-Aug-2026 | Your Result |
| Priya | 17-Aug-2026 | 28-Aug-2026 | Your Result |
| Amit | 31-Aug-2026 | 11-Sep-2026 | Your Result |
| Neha | 14-Sep-2026 | 25-Sep-2026 | Your Result |
Complete the report using the NETWORKDAYS function.
Key Takeaways
- NETWORKDAYS calculates working days between two dates.
- It automatically excludes Saturdays and Sundays.
- The starting and ending dates are included when they are working days.
- The holidays argument is optional.
- You can provide multiple holiday dates in a cell range.
- Use absolute references to keep the holiday range fixed when copying formulas.
- The function is useful for HR, attendance, payroll, project planning, and business reporting.
- NETWORKDAYS uses Saturday and Sunday as weekends by default.
Frequently Asked Questions (FAQs)
1. What is the NETWORKDAYS function in Excel?
NETWORKDAYS calculates the number of working days between two dates, excluding Saturdays and Sundays by default.
2. What is the syntax of NETWORKDAYS?
The syntax is:
=NETWORKDAYS(start_date,end_date,[holidays])
3. Does NETWORKDAYS exclude Saturdays and Sundays?
Yes. It automatically excludes Saturday and Sunday from the working-day calculation.
4. Can NETWORKDAYS exclude public holidays?
Yes. Provide a list of holiday dates in the optional holidays argument.
5. Are the starting and ending dates included in NETWORKDAYS?
Yes. Both dates are included if they fall on working days and are not listed as holidays.
6. Can NETWORKDAYS calculate working days for a complete month?
Yes. Provide the first and last dates of the month to calculate the number of weekdays in that month.
7. What happens if the starting date is greater than the ending date?
NETWORKDAYS can also calculate the result when the starting date is later than the ending date. It returns a negative working-day count.
8. Can NETWORKDAYS calculate employee attendance?
Yes. It can count the weekdays between an employee’s attendance start and end dates, excluding any holidays you provide.
9. What is the difference between NETWORKDAYS and NETWORKDAYS.INTL?
NETWORKDAYS uses Saturday and Sunday as weekends by default. NETWORKDAYS.INTL allows you to specify different weekend days.
10. Can NETWORKDAYS exclude multiple holidays?
Yes. You can provide a range containing multiple holiday dates, and Excel excludes the dates that fall within the specified period.

