WORKDAY.INTL in WPS Spreadsheet: Schedule Dates with Custom Weekends
Find a working-day deadline using explicit weekend masks and holiday dates, with independent calendar checks.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer
With a start date of October 19, 2026, a five-working-day offset, Saturday/Sunday weekends and October 21 excluded as a holiday, WORKDAY.INTL has the independently expected result October 27, 2026. Format the result cell as a date; the underlying result is a date serial number.
Syntax and defaults
WORKDAY.INTL(start_date, days, [weekend], [holidays])
start_date and days are required. The official lesson documents truncation of fractional start-date serials and day offsets. Omitted weekend, or numeric code 1, means Saturday and Sunday. Omitted holidays supplies no holiday exclusions. These examples use integer offsets and explicit arguments to keep the calendar easy to audit.
A seven-character weekend mask runs Monday through Sunday: 1 means nonworking, 0 means working. Quote the mask so leading zeros survive. "0000011" represents Saturday/Sunday; "0000110" represents Friday/Saturday. The lesson identifies "1111111" as invalid. Other numeric codes exist, but the examples need only code 1 and these explicit masks.
Worked worksheet: a five-day preparation window
| Cell | Enter | Purpose |
|---|---|---|
| B2 | =DATE(2026,10,19) |
Monday start |
| B3 | 5 | Working-day offset |
| B4 | 1 | Saturday/Sunday weekend |
| E2 | =DATE(2026,10,21) |
Excluded Wednesday |
Enter =WORKDAY.INTL(B2,B3,B4,E2:E2) in B6 and apply a date format. Expected result: 2026-10-27. The five counted dates after the start are October 20, 22, 23, 26 and 27. The start itself is not counted in this positive-offset example. Without the holiday, =WORKDAY.INTL(B2,B3,1) is expected to return 2026-10-26.
To check the explicit mask, use =WORKDAY.INTL(B2,B3,"0000011",E2:E2). It has the same October 27 expectation as code 1.
Advanced example: a Friday/Saturday weekend
On a separate area, put =DATE(2026,10,22) in H2 and 3 in H3. Enter =WORKDAY.INTL(H2,H3,"0000110") in H4. The independently expected result is 2026-10-27: Friday October 23 and Saturday October 24 are excluded; Sunday October 25 is the first working day, followed by Monday and Tuesday.
This is why adding a fixed number of calendar days is not a substitute. Also check which holiday list belongs to the team concerned; a weekend mask alone does not supply regional public holidays automatically.
Direction, errors and practical limits
The lesson defines positive offsets as forward, negative offsets as backward and zero as the starting date. For controlled checks, =WORKDAY.INTL(DATE(2026,10,26),-1,1) is expected to return 2026-10-23, while =WORKDAY.INTL(DATE(2026,10,24),0,1) is expected to preserve 2026-10-24, even though that date is Saturday. These expectations follow the documented rules; they are not native execution results.
The lesson documents #NUM! for out-of-range start or holiday dates and an invalid resulting date. An incorrect mask length or characters other than 0/1 produce documented #VALUE!. It identifies the all-nonworking mask as invalid without a separate error-label claim here.
Use DATE inputs rather than ambiguous date text. Keep holiday cells as genuine dates, not labels. The function computes a date, not working hours, shifts or a legal deadline. Do not infer a statutory filing rule from a weekday calendar. See DATE and WORKDAY for related date tasks.
Availability and verification
The official WPS WORKDAY.INTL lesson was checked on October 19, 2026. Its edition banner identifies WPS Office for Windows Personal. It does not establish an exact minimum build, English-global availability or support on Mac, Linux, web and mobile. The calculations above are independent expected results, not observed WPS outputs. Native execution and genuine current-application screenshots remain unverified.
Browse the WPS function library.