NETWORKDAYS.INTL in WPS Spreadsheet: Sunday-Only Working Days
Count a documented Sunday-only working week with an explicit holiday, preserve fixed holiday references and distinguish scheduled days from actual attendance.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
NETWORKDAYS.INTL counts calendar dates treated as working days after applying a weekend pattern and holiday exclusions. The WPS walkthrough establishes weekend code 11 as Sunday only. In that pattern Saturday remains a potential working day.
This guide deliberately focuses on that documented pattern and one clear Monday-through-Sunday example. It does not claim that a day count proves actual attendance, hours worked or a payroll entitlement.
Syntax and source limitation
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Start and end dates are required. Weekend and holidays are optional in the source syntax, but both are explicit in the original example. The lesson’s formal numeric-code table contains corrupted entries such as “1.2” and “utf-16”; the separate walkthrough table and narrative clearly establish code 11 for Sunday only.
The source also discusses weekend strings and other codes. Their general behavior, reverse-date ranges, omitted defaults, all-one masks and exact date-serial boundaries are outside this guide’s independent control. Do not reconstruct damaged codes from another spreadsheet product.
Build an original working week
Use this fictional calendar:
| Cell | Calendar date | Suggested numeric-date formula |
|---|---|---|
| A2 | Monday, October 5, 2026 | =DATE(2026,10,5) |
| B2 | Sunday, October 11, 2026 | =DATE(2026,10,11) |
| D2 | Wednesday, October 7, 2026 | =DATE(2026,10,7) |
Enter the following formula in F2:
=NETWORKDAYS.INTL(A2,B2,11,$D$2:$D$2)
The independent expected result is 5. The holiday is a fictional local closure supplied explicitly; it is not an assertion that this date is a public holiday.
Verify by enumerating every date
| Date | Weekday | Counted? | Reason |
|---|---|---|---|
| October 5 | Monday | Yes | Ordinary scheduled day |
| October 6 | Tuesday | Yes | Ordinary scheduled day |
| October 7 | Wednesday | No | Explicit holiday in D2 |
| October 8 | Thursday | Yes | Ordinary scheduled day |
| October 9 | Friday | Yes | Ordinary scheduled day |
| October 10 | Saturday | Yes | Code 11 excludes Sunday only |
| October 11 | Sunday | No | Weekend day |
There are seven calendar dates including both endpoints. Excluding the one Sunday leaves six potential working days; excluding the separate Wednesday holiday leaves five. This enumeration checks the bounded example without relying on a runtime or a guessed serial-date origin.
Keep holiday references fixed when copying
The absolute holiday reference $D$2:$D$2 prevents the holiday location from moving if the formula is copied to another row. Start and end references may change when different rows intentionally contain different schedules. A relative holiday range can silently describe different calendars after copying.
The vendor example’s first row runs from April 15 through May 26, 2019, with Sunday-only weekends and holidays May 1 through May 4. Its displayed result 32 agrees with six complete weeks: 42 inclusive dates minus six Sundays minus four separate holidays. Later downfilled vendor formulas move relative holiday ranges, so those displayed results should not be treated as one unchanged common holiday list.
Practical interpretation and troubleshooting
A scheduled-day count does not include partial-day fractions or time worked. If a separate fictional estimate assigns eight hours to each of the five counted days, the arithmetic total is 40 hours; that is an additional assumption, not an hours result returned by NETWORKDAYS.INTL.
Use actual numeric dates rather than ambiguous text and keep the declared weekend and holiday policy visible. The lesson’s error prose is partly corrupted and the original control does not test invalid dates, malformed masks or duplicate holiday handling. No exact error token or unsupported weekend code is inferred.
For date construction see DATE. NETWORKDAYS has its own weekend contract and should not be assumed to reproduce this Sunday-only schedule. The original calendar and source walkthrough provide bounded documentation/math evidence only.
Availability and evidence scope
The official WPS lesson is dated 2019-05-27 and explicitly labels WPS Office for Windows Personal. Its numeric build is unspecified. This documents the function by that date; it does not establish first introduction, the last functioning build, other-platform parity or a retirement/deprecation history.
The official lesson was rechecked on October 19, 2026. Original examples are documentation-derived independent calculations, not WPS or other spreadsheet-engine executions. The counted dates check the stated calendar only; they do not establish actual attendance or payroll rules.