NETWORKDAYS counts working days between dates, excluding Saturdays, Sundays and an optional range of holidays. ONLYOFFICE explicitly documents the three-argument order and optional holidays, but the terse article does not explicitly spell out endpoint inclusivity, duplicates in holiday lists, reversed dates or exact error behaviour. We therefore label numeric fixture results as Excel-compatible model predictions, not observed ONLYOFFICE results.

NETWORKDAYS answers a different question than DAYS: weekends do not count, and the default weekends are Saturday and Sunday. The documentation for NETWORKDAYS.INTL explicitly adds configurable weekend parameters; use that function for nonstandard workweeks instead of pretending NETWORKDAYS takes a weekend argument.

=NETWORKDAYS(start_date, end_date, [holidays])

The ONLYOFFICE function page is an unversioned English web reference. Required/optional designations above reflect the brackets in its displayed syntax; no undocumented default, error code or argument coercion is inferred. Official NETWORKDAYS source, accessed 2026-10-11.

Open a blank worksheet and select any empty cell for the formula. Use the copy-ready examples below, entering a holiday into F2 where shown. Never enter the date text directly if the editor does not recognize its locale; use DATE(…) to construct it.

Copy any expression in Copy-ready formula to a result cell. If that row has a holiday, first enter the shown value into F2 using =DATE(year,month,day). When testing a new row, change F2 accordingly. Dates shown in the outcome column require date formatting for EDATE, EOMONTH and WORKDAY; NETWORKDAYS returns an integer. The listed results are independent Python predictions, not a record of ONLYOFFICE execution.

The accompanying CSV is a fixture of input dates and independently predicted output, not a file executed in ONLYOFFICE. The dates were calculated using Python’s datetime.date, calendar.monthrange and ordinary Monday–Friday looping; that separate mathematical implementation may differ in undocumented edge cases from ONLYOFFICE’s actual engine.

First formula to paste

=NETWORKDAYS(DATE(2026,10,9),DATE(2026,10,19))

Independent expected result: 7. Paste this formula into an empty cell (no other input cells are needed for this first example), then format it as a date when applicable. This is a runnable test to perform in a native ONLYOFFICE editor; the outcome has not been observed there.

1. Holiday-aware workdays

=NETWORKDAYS(DATE(2026,10,9),DATE(2026,10,19),$F$2:$F$2)

Independent expected result: 6. Put =DATE(2026,10,12) in F2; expected removal of one Monday weekday.

2. Same-day business rule

=NETWORKDAYS(DATE(2026,10,12),DATE(2026,10,12))

Independent expected result: 1. One Monday in the interval under the independent inclusive model.

3. Weekend-only interval

=NETWORKDAYS(DATE(2026,10,11),DATE(2026,10,11))

Independent expected result: 0. Sunday only; useful for endpoint-rule audit.

4. Days versus NETWORKDAYS

=DAYS(DATE(2026,10,19),DATE(2026,10,9))

Independent expected result: 10. DAYS is elapsed calendar days, while NETWORKDAYS predicts 7 weekdays for the same end points.

If your workbook displays #VALUE!, #NUM!, or another result, do not ascribe a specific ONLYOFFICE exception rule to it without a reproducible native experiment: the concise function page does not establish detailed input coercion and errors. Preserve the exact input cell types and locale. A visually formatted date is not by itself proof that the stored value is a valid date.

WORKDAY finds a future or past business date from an offset; it does not count business days in a range.

• WORKDAY — confirmed vendor reference; not a claim that a corresponding Spreadsheet-Tutorials.com tutorial is live.
• NETWORKDAYS.INTL — confirmed vendor reference; not a claim that a corresponding Spreadsheet-Tutorials.com tutorial is live.
• DAYS — confirmed vendor reference; not a claim that a corresponding Spreadsheet-Tutorials.com tutorial is live.

Cross-application compatibility: Microsoft Excel’s NETWORKDAYS documentation gives the same English signature. Microsoft documents the same syntax and offers example calculations. Excel’s published examples are consistent with inclusive endpoints, but this exact endpoint rule has not been natively confirmed for the specific ONLYOFFICE build. Function availability and error semantics in Google Sheets, LibreOffice Calc and older workbook formats have not been experimentally checked here; don’t assert universal equivalence from the name alone.

These samples use the English formula names with commas and begin with =. ONLYOFFICE’s function entry guide explains its function picker and Formula tab, while the Advanced Settings guide documents Formula Language, Region, customizable numeric separators and the 1904 date system option. A machine configured for another language or regional syntax should use the editor’s function picker to confirm the correct localized formula; the short function references do not establish every locale’s argument separator. Use DATE(year,month,day) instead of ambiguous date strings and apply an explicit ISO-like date display to results.

Edition evidence (checked 2026-10-11): The official unversioned English ONLYOFFICE help page documents the named function but does not state its first-supported Desktop/Web/mobile build. ONLYOFFICE Docs 10.0 was announced 2026-10-10; the independent Desktop Editors changelog currently lists 9.4.0 released 2026-05-19. These release references establish two distinct version streams, not native function test coverage. Availability and behaviour in a specific build, mobile editor, workbook imported from Excel or old-format .xls file remain unverified. The 1904 option changes numeric date serials; avoid comparing raw serial integers across workbooks without first checking workbook settings.

How to verify a discrepancy in your edition

1. Write down the application (ONLYOFFICE Docs/web or Desktop), exact version/build, OS/browser, workbook date system and formula language.
2. Enter the numeric DATE fixtures shown here into a new workbook, not text parsed from a CSV locale.
3. Format date results as yyyy-mm-dd where available, while retaining a numeric-format copy if serial debugging is necessary.
4. Compare the displayed outcome against the independently expected column; an expected result is not a screenshot, observation or claim that the software actually produced it.
5. If any outcome differs, preserve both the formula and actual output and flag the guide for correction; do not publish the expected prediction as tested truth.

• ONLYOFFICE Spreadsheet Editor — function documentation
• NETWORKDAYS.INTL
• WORKDAY
• DAYS
• function entry guide
• Advanced Settings guide
• ONLYOFFICE Docs 10.0

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

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.