=WORKDAY.INTL(start_date; days; [weekend]; [hol_range])

Result: A calendar date value/serial, to be formatted as a Date. Do not assume a custom weekend string from Excel works in Zoho Sheet. For a conventional Saturday/Sunday schedule, WORKDAY is simpler.

Zoho-documented numeric weekend values

Zoho documents code 1 as the default when weekend is omitted. Values not in this table have not been established for Zoho by the reference.

Create a sheet named BusinessCalendar. Enter the table into columns A:F, beginning at row 1. Values in B and C must be actual date cells; set the date format, or type =DATE(2026;10;5) rather than relying on CSV date detection. D and E are integers. The optional downloadable CSV contains the same source values but does not prove that Zoho Sheet recognized the dates on import.

Enter these fictional business-closure dates as real dates in H2:H5. They are teaching data, not an authoritative public-holiday list or a claim that every employer observes them.

When filling formulas down, lock the holiday range as $H$2:$H$5. Enter semicolon-separated formulas as published in Zoho’s web reference; another environment or regional setting may present a different separator. Expected dates below use YYYY-MM-DD to avoid formatting ambiguity. All expected values were calculated with an independent Python date-iteration model, not executed in Zoho Sheet.

1. Enter Custom-calendar due date in I1. Format I2:I9 as date cells. In I2, enter =WORKDAY.INTL(B2;D2;E2;$H$2:$H$5).
2. B2 = Oct 5, D2 = +5, E2 = 1 (standard Saturday/Sunday). Counting Oct 6, 8, 9, 13, 14 leads to 2026-10-14 after skipping the sample closures.
3. Fill the formula through I9; E2:E9 changes each row’s weekend definition while $H$2:$H$5 remains locked.
4. For row 6, B6 = Oct 14, D6 = -3 and E6 = 17 (Saturday-only). Count backward Oct 13 (1), Oct 11 (2, Sunday is a workday under code 17), Oct 9 (3). Oct 12 is excluded as a closure and Oct 10 as Saturday. Expected I6: 2026-10-09.
5. For row 7 with E7 = 6 (Thursday/Friday excluded), the independently calculated forward due date is 2026-10-31. A Saturday can legitimately be a workday under this code.

Expected results for all practice rows (independent model, NOT Zoho execution):

Advanced application: choose the correct team calendar

Assign numeric weekend codes in E2:E9: 7 for Friday/Saturday, 11 for Sunday-only, 17 for Saturday-only and 1 for the default. Use =WORKDAY.INTL(B2;D2;E2;$H$2:$H$5) to calculate each team’s promise date. For J-105, a Saturday-only off-day gives 2026-10-09, versus 2026-10-08 under the usual Saturday/Sunday pattern with the same closures. This difference directly affects whether an order meets its SLA.

Advanced application: live overdue flag without hard-coded dates

=IF(WORKDAY.INTL(B2;D2;E2;$H$2:$H$5)<TODAY();"Late";"Not yet late")

This classification recalculates, so it has no fixed result independent of the evaluation date. If a listed closure applies to only one team, pass that team’s vetted holiday range instead of a company-wide shared list.

• Weekend choice: Use Zoho’s numeric code table, not a guessed numbering scheme. 11 means Sunday-only, 17 Saturday-only. A code such as 8 is undocumented; native Zoho error output has not been observed.
• Excel-only documented string option: Microsoft Excel documents binary weekend strings such as "0000011". Zoho’s linked help page shows numeric codes only. String weekend behavior in Zoho is UNKNOWN until tested; do not advertise this portability.
• Holiday overlap depends on weekend pattern: A Saturday closure is redundant under code 17 but potentially meaningful under code 11. Do not remove holiday entries on the assumption that every team has a Saturday/Sunday weekend.
• Backwards due dates: Negative days are supported by Zoho’s description. Fractional offsets and zero-day edge behavior are not specified in this source; test them natively before stating an exact rule.
• Date-as-number formatting: The return may display as a serial unless formatted as a Date. It is not necessarily an error.
• Error diagnosis: Verify actual date values in B/C, numeric D/E, real date cells H2:H5, the $ anchors, and semicolon delimiters. Zoho’s generic #VALUE!, #REF!, and #NAME! descriptions do not establish every case-specific error response.

• Microsoft Excel documents a comma-separated syntax for the corresponding function. Zoho’s linked web-help reference uses semicolons. Copying an Excel formula unchanged may therefore need argument-separator changes, depending on the Zoho environment and file mode. See the Microsoft references below for the cross-software comparison; do not infer that formulas are universally interchangeable.
• Zoho’s current help pages establish these functions for the current documentation scope. They do not give a first-supported version, a complete historical compatibility matrix, or a guarantee that every cloud, desktop-beta, mobile, or offline workflow works identically. The Zoho Sheet desktop beta announcement says the desktop apps initially provide a subset of web features.
• Google’s products may offer function names that look similar. This guide does not assert identical edge cases, weekend-string handling, or error codes in Google Sheets without a separate function-by-function native test.

Important compatibility difference: The Zoho reference verifies the numeric code table. Microsoft documents seven-character binary weekend strings in Excel, but this Zoho reference does not. String-code support in Zoho is not verified and must not be inferred from Excel.

• WORKDAY — prepared or planned review guide, link pending verified publication.
• NETWORKDAYS.INTL — prepared or planned review guide, link pending verified publication.
• TODAY — prepared or planned review guide, link pending verified publication.
• WEEKDAY — prepared or planned review guide, link pending verified publication.

These are editorial queue references, not confirmed live links. Publication staff should connect only URLs already published and verified.

• Zoho Sheet: WORKDAY.INTL official function reference — directly checked 2026-10-11.
• Microsoft Excel: WORKDAY.INTL reference — checked 2026-10-11 for differences, not evidence of Zoho behavior.
• Zoho Sheet desktop beta announcement — checked 2026-10-11 for product/platform scope; does not certify this individual formula in all desktop modes.

• Zoho Sheet — function documentation
• Zoho Sheet desktop beta announcement

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.