NETWORKDAYS.INTL in Collabora Office: Count Workdays with Custom Weekends
Count inclusive working dates in Collabora NETWORKDAYS.INTL, use weekend codes or masks, and audit holiday overlaps with an explicit calendar.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =NETWORKDAYS.INTL(DATE(2026;10;16);DATE(2026;10;26)) has independently expected result 7. Both endpoints count when they are working days; the default weekend is Saturday and Sunday.
Syntax and required inputs
=NETWORKDAYS.INTL(StartDate; EndDate [; [Weekend] [; Holidays]])
StartDate and EndDate define the inclusive interval. Weekend optionally defines weekly nonworking days. Holidays optionally supplies additional nonworking dates, including as a cell range. To supply holidays while omitting Weekend, leave its argument position empty, as in =NETWORKDAYS.INTL(A2;B2;;F2:F3).
Create dates with DATE or use genuine date values. Ambiguous date-looking text and bare arithmetic such as 2026-10-16 are not a reliable way to specify a date.
Complete weekend choices
| Code | Nonworking weekdays |
|---|---|
| 1 or omitted | Saturday, Sunday |
| 2 | Sunday, Monday |
| 3 | Monday, Tuesday |
| 4 | Tuesday, Wednesday |
| 5 | Wednesday, Thursday |
| 6 | Thursday, Friday |
| 7 | Friday, Saturday |
| 11 | Sunday only |
| 12 | Monday only |
| 13 | Tuesday only |
| 14 | Wednesday only |
| 15 | Thursday only |
| 16 | Friday only |
| 17 | Saturday only |
Alternatively supply a quoted seven-character mask, ordered Monday through Sunday. A 1 marks a nonworking day; 0 marks a working day. Thus "0000011" means Saturday and Sunday, and "0000001" means Sunday only. The help explicitly says "1111111" is invalid; characters other than 0 and 1 or a length other than seven do not meet the documented format.
Example: audit every included date
Put =DATE(2026;10;16) in A2 and =DATE(2026;10;26) in B2. With the default weekend, the seven included dates are October 16, 19, 20, 21, 22, 23, and 26.
Put =DATE(2026;10;20) in F2 as a holiday. Then:
=NETWORKDAYS.INTL(A2;B2;1;F2)
has independently expected result 6, excluding October 20. The same interval under Sunday-only weekends, =NETWORKDAYS.INTL(A2;B2;11;F2), has expected result 8. Saturdays 17 and 24 become working dates, while Sundays 18 and 25 remain excluded.
The mask form =NETWORKDAYS.INTL(A2;B2;"0000001";F2) expresses the same Sunday-only calendar. Use straight quotation marks when entering the mask, not typographic curved quotes copied from prose.
Advanced example: a holiday that overlaps a weekly closure
For this same interval, use mask "0101000": Tuesday and Thursday are nonworking. There are 9 otherwise eligible dates in the eleven-day interval after excluding Tuesday October 20 and Thursday October 22.
With October 20 also in F2, =NETWORKDAYS.INTL(A2;B2;"0101000";F2) still has independent expectation 9. That date is already excluded by the weekly mask; it is not a second working day to subtract.
The independent audit treats eligible dates as dates satisfying both conditions: not a weekly closure and not a listed holiday. Do not subtract the raw number of holiday rows from a weekday total, because holidays can fall outside the interval or on existing nonworking days.
Advanced use: compare staffing calendars transparently
Store different weekend codes in D5:D7, such as 1, 7, 11, and calculate =NETWORKDAYS.INTL($A$2;$B$2;D5;$F$2) down the adjacent column. With the stated dates and holiday, independent counts are 6, 6, and 8.
Identical totals do not prove identical working dates. Code 1 and code 7 give six days here but exclude different weekdays. Keep the code description beside the result, especially when coordinating teams with different working weeks.
For a simple Saturday/Sunday calendar, NETWORKDAYS is a related guide. The INTL variant’s extra weekend input is meaningful and should not be dropped when exchanging formulas.
Errors and troubleshooting
The vendor says text and empty cells in data ranges are ignored. A holiday imported as text can silently fail to exclude its intended date; validate the holiday values, not just their visual format. The help recommends value highlighting when investigating text in ranges.
Check mask length, Monday-first order, and the distinction between 1 as a code and "1" as text. The dedicated section does not establish a complete native error-code matrix or every reversed-date boundary, so those behaviors are not certified here.
The help identifies this function as outside OpenDocument 1.3 OpenFormula, with namespace COM.MICROSOFT.NETWORKDAYS.INTL. The name does not certify Microsoft Excel parity or a cross-product round trip.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: NETWORKDAYS.INTL (checked October 17, 2026).
- Editorial testing standards.