WORKDAY.INTL in Collabora Office: Find Dates After Custom Working-Day Offsets

=WORKDAY.INTL(StartDate; Days [; Weekend [; Holidays]])

StartDate is the starting date. Days is the working-day offset: positive for a later date, negative for an earlier one. Weekend defines recurring weekly closures; Holidays supplies additional nonworking dates, optionally as a cell range.

For the nonzero offsets in this guide, counting begins after or before the start date, rather than counting that date as the first day. The vendor’s fixed examples support this offset interpretation. Days is not an inclusive count of working dates in a period.

Use DATE for reproducible inputs. A date-looking arithmetic expression is not a date value. Keep the result numeric and apply date formatting instead of replacing it with manually typed text.

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.

Put =DATE(2026;10;16) in A2, 5 in B2, and =DATE(2026;10;20) in F2. The start is Friday and F2 is a Tuesday closure.

=WORKDAY.INTL(A2;B2;1;F2)

The independently expected result is 2026-10-26. The counted days are October 19, 21, 22, 23, and 26. October 20 is skipped as a holiday, and both weekends are skipped.

Without Holidays, =WORKDAY.INTL(A2;B2) gives the independent date 2026-10-23. That three-calendar-day difference reflects the intervening weekend, not three additional working days.

Leaving the Weekend slot empty while retaining the holiday, =WORKDAY.INTL(A2;B2;;F2), uses the same default calendar as code 1.

Use the same start, offset, and holiday, but replace Weekend with 11, Sunday only. The independent result becomes 2026-10-23; counted dates are October 17, 19, 21, 22, and 23.

With code 7, Friday and Saturday are nonworking. The independent result is 2026-10-25; counted dates are October 18, 19, 21, 22, and 25. A Sunday deadline is valid for that calendar because Sunday is a working day.

These examples show why a generic “add seven calendar days” shortcut is unreliable. Keep the weekend definition and holiday range attached to each schedule instead of storing only the final date.

Put =DATE(2026;10;23) in A5 and −3 in B5. With the same October 20 holiday:

=WORKDAY.INTL(A5;B5;1;F2)

has independent result 2026-10-19. Moving backward, the three eligible dates are October 22, 21, and 19. October 20 is skipped. This is useful for a preparation date before a fixed milestone, provided the chosen calendar actually applies.

WORKDAY is a related simpler working-day-offset guide. Do not remove INTL’s weekend argument from a formula that depends on a custom working week.

If the result is a large integer, check its date format. If it lands on an unexpected weekday, inspect the weekend code or the Monday-first mask before changing the offset. A holiday list must contain the intended date values; appearance alone does not establish correct date storage.

This guide does not establish native handling of fractional Days, zero offsets on nonworking starts, duplicate or text holiday entries, or every invalid-input error code. Its calculations use nonzero integer offsets, valid masks, and explicit date values. The all-ones mask is explicitly invalid in the vendor help.

The vendor identifies the function as outside OpenDocument 1.3 OpenFormula, with namespace COM.MICROSOFT.WORKDAY.INTL. This does not establish identical behavior in another spreadsheet or guarantee an exported workbook’s results.

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.

• Collabora Office 26.04: WORKDAY.INTL (checked October 17, 2026).
• Editorial testing standards.