Buzz
This article provides a detailed guide on calculating workdays using Networksday.
1. Structure and significance of the function
- Structure: Networksday(start_date, end_date, [holidays]).
Among them:
+ commencement_day: Commencement day.
+ concluding_day: Concluding day.
+ [days_off]: Days off.
This function calculates the total working days excluding holidays and weekends.
Example 2
A dataset exists for computing the total working days of employees.
To compute the total working days without considering holidays.
Input the formula NETWORKDAYS (C3, D3).
2.2. Calculate the total working days with 1 day off.
For employee Trần Minh with 1 holiday -> subtract the total working days by the holiday.
Enter the formula: NETWORKDAYS (C3, D3, I3).
Calculating total working days excluding holidays.
For employee Vu Hang who took 2 sick leave days and public holidays, use the formula: NETWORKDAYS(C4, D4, E4:E5).
Note: Apply the formula under section '2.3 Calculating total working days excluding holidays' for all scenarios.
Wishing you all success!
