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.
2.1. Calculate the total working days without holidays
Enter the formula NETWORKDAYS (C3, D3) .
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).
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).
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!