=WORKDAY(start_date; days; [hol_range])

Result: A calendar date value/serial, to be formatted as a Date. WORKDAY assumes Saturday/Sunday weekends. For Friday/Saturday or one-day weekends use WORKDAY.INTL; do not approximate a different schedule by repeatedly adding calendar days.

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 Standard-calendar due date in I1. Format I2:I9 as dates, not whole-number general cells. Enter =WORKDAY(B2;D2;$H$2:$H$5) in I2.
2. Starting on October 5, count the following available dates: Oct 6 (1), 8 (2), 9 (3), 13 (4), 14 (5). October 7 and 12 are excluded by H2:H3, and October 10–11 are excluded weekends. The result is October 14, 2026.
3. Fill I2:I9. For a no-closure comparison, =WORKDAY(B2;D2) is expected to produce 2026-10-12, which is a Monday but is part of the fictional closure calendar in this practice data.
4. Row 4 shows backward counting: B4 is Friday October 9 and D4 is -4, so it moves to Friday October 2, 2026 with the supplied H2:H5 closure calendar. Zoho explicitly says negative days count backward.
5. If you see a date serial instead of a formatted date, change the display format of the result cell. Do not manually type a date-looking string into the computed result cell.

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

Advanced application: SLA deadline and live late flag

Suppose the contract promises a reply within 5 business days, excluding intake day and closures. Use =WORKDAY(B2;5;$H$2:$H$5) to produce the date 2026-10-14 for row 2. A separate dynamic status formula can be:

=IF(WORKDAY(B2;D2;$H$2:$H$5)<TODAY();"Late";"Still on schedule")

Because TODAY() recalculates, this label has no single fixed expected output across different run dates. If the due date itself counts as late, change < to <= after confirming your SLA policy. If the start date falls on a weekend or closure, test the exact contractual start-counting rule; do not assume that shifting the start date manually is equivalent.

Advanced application: back-plan an internal review

With a launch on Friday October 9 (B4) and four business days needed before launch (D4 = -4), =WORKDAY(B4;D4;$H$2:$H$5) independently yields 2026-10-02. This is a backward working-day calculation, not subtraction of four calendar days.

• Result type: A date is stored as a serial. Number formatting might show 46xxx or another integer instead of a date; that alone does not mean the formula failed.
• Counting convention: WORKDAY(start;5) is conceptually a date five valid workdays after the start, whereas NETWORKDAYS(start;end) counts qualifying endpoints inclusively. They are not interchangeable.
• Negative offsets: Zoho explicitly documents backwards counting. This guide independently models it; exact outcomes have not been checked inside Zoho.
• Fractional offsets and zero days: Excel documents truncation of fractional days and zero-days returning the start date. The linked Zoho page does not establish these precise edge rules. Prefer integer offsets; label fractional and zero behavior native test required.
• Duplicate weekend holidays: A listed Saturday/Sunday is already excluded. The independent model counts unique qualifying business days; holiday duplicates/overlaps should be tested in Zoho for full parity.
• Invalid dates and references: Try DATE(2026;10;5) to avoid locale-ambiguous text. Check #VALUE! for argument problems, #REF! for broken ranges, and #NAME! for spelling/separator mistakes, as described by Zoho’s general errors.

• 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.

• WORKDAY.INTL — prepared or planned review guide, link pending verified publication.
• NETWORKDAYS — prepared or planned review guide, link pending verified publication.
• EDATE — prepared or planned review guide, link pending verified publication.
• TODAY — 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 official function reference — directly checked 2026-10-11.
• Microsoft Excel: WORKDAY 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.