How to Count Company Holidays as Working Days with NETWORKDAYS.INTL in WPS Spreadsheets
Question details
The user needs NETWORKDAYS.INTL to calculate working days for selected weekdays while treating company holidays as working days instead of excluding them.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- Calculating working days for a custom workweek in a WPS Spreadsheets workbook where company holidays should be included as working days.
- Observed behavior
- NETWORKDAYS.INTL normally treats the holiday argument as non-working days, but the user wants company holidays counted as working days.
Open the workbook in WPS Spreadsheets and identify the cells containing the start date, end date, and the weekend code for your work schedule. Decide whether to leave out the holiday range entirely, because NETWORKDAYS.INTL always excludes any dates provided in its fourth argument.
Omit the Holiday Argument to Include Company Holidays
Use this when company holidays must be counted as regular working days and only weekends should be non-working.
NETWORKDAYS.INTL treats any dates in the optional holiday argument as non-working days. To count company holidays as working days, do not reference the holiday range in the formula.
Click the cell where you want the working day total to appear in WPS Spreadsheets.
Type =NETWORKDAYS.INTL(start_date,end_date,weekend) and do not add the optional fourth holiday argument.
Use cell references such as =NETWORKDAYS.INTL(A2,B2,1) for a standard Saturday–Sunday weekend, or use a custom weekend code.
Press Enter to return the number of working days; company holidays are included because no holiday range is supplied.
Count Friday, Saturday, and Sunday as Working Days
Use this when you need a custom weekend code for a Friday–Sunday workweek instead of the standard weekend.
Calculate Working Days Including Company Holidays in WPS Spreadsheets
Use NETWORKDAYS.INTL in WPS Spreadsheets to count working days with a custom workweek and omit the holiday argument, so company holidays are included as regular working days.
- 1. Open your workbook: Launch WPS Office and open the workbook in WPS Spreadsheets.
- 2. Select the result cell: Click the cell where you want the NETWORKDAYS.INTL result to appear.
- 3. Enter the working-day formula: Type =NETWORKDAYS.INTL(start_date,end_date,weekend_code) and omit the holiday range.
- 4. Press Enter to calculate: Press Enter to count working days including company holidays.
Frequently Asked Questions
Does NETWORKDAYS.INTL always exclude the holiday argument?
Yes. Any date range supplied as the fourth argument is treated as non-working days. To count company holidays as working days, omit that argument from the formula.
How can I count Friday, Saturday, and Sunday as working days in WPS Spreadsheets?
Use =NETWORKDAYS.INTL(start_date,end_date,"1111000"). The weekend string 1111000 marks Monday through Thursday as non-working and Friday through Sunday as working.
Can I use a cell reference for the weekend code instead of typing it in the formula?
Yes. Put the weekend number or string in a cell, such as C2, and use =NETWORKDAYS.INTL(A2,B2,C2). WPS Spreadsheets accepts the same weekend codes as Microsoft Excel.
What should I do if only some company holidays should be excluded?
Create a holiday range that contains only the dates that should be non-working, and add that range as the fourth argument, such as =NETWORKDAYS.INTL(A2,B2,1,D2:D10). Dates outside that range, including other company holidays, will still be counted as working days.
