Instructions for using the Networksday function in excel

The following article details the calculation of workdays using Networksday.

1. Structure and meaning of functions

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

Inside:

+ 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.

Instructions for using the Networksday function in excel Picture 1

2.1. Calculate the total working days without holidays

Enter the formula NETWORKDAYS (C3, D3) .

Instructions for using the Networksday function in excel Picture 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).

Instructions for using the Networksday function in excel Picture 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).

Instructions for using the Networksday function in excel Picture 4

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

Good luck!