How to Use the Networksday Function in Excel

This updated guide explains how to Use the Networksday Function in Excel through clear steps, practical examples, and important checks that help prevent common errors.

1. Structure and Meaning of Functions

- Structure: Networksday (start_day, end_day, [holidays]) .

Arguments

+ start_day: The start date.

+ end_day: End date.

+ [holidays]: Holidays.

- Meaning: The function returns the total number of working days except weekends and holidays.

2. for Example

There is a data sheet to calculate the total number of employees working days.

Use the Networksday Function in Excel � 2. for Example screenshot 1

2.1. Calculate the Total Working Days Without Holidays

Enter the formula NETWORKDAYS (C3, D3) .

Use the Networksday Function in Excel � 2.1. Calculate the Total Working Days Without Holidays screenshot 2

2.2. Calculate the Total Working Day with 1 Day Off

For Tran Minh employees, there is one public holiday -> total working days minus holidays.

Enter the formula: NETWORKDAYS (C3, D3, I3).

Use the Networksday Function in Excel � 2.2. Calculate the Total Working Day with 1 Day Off screenshot 3

2.3. Calculate the Total Number of Working Days with More Than 1 Day Off

With Vu Hang employees have 2 days off sick and holidays -> enter the formula: NETWORKDAYS (C4, D4, E4: E5).

Use the Networksday Function in Excel � 2.3. Calculate the Total Number of Working Days with More Than 1 Day Off screenshot 4

Note: You should apply the formula in " 2.3 Calculating the total working days with more than 1 day off " for all cases.

FAQ

What is the easiest way to Use the Networksday Function in Excel?

Start with the requirements in this guide, then follow each step in order. Check the result after every major change so problems are easier to identify.

Can beginners follow these instructions?

Yes. The process is organized into practical steps, and you can repeat any step before moving forward.

What should I check if the method does not work?

Confirm your software or device version, permissions, settings, file format, and internet connection when the task depends on online services.