NETWORKDAYS.INTL function
Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| start_date | Yes | A date that represents the start date."2012-10-1" |
| end_date | Yes | A date that represents the end date."2013-3-1" |
| weekend | No | is a weekend number or string that specifies when weekends occur.6 |
| holidays | No | An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays."2012-11-22" |
Try NETWORKDAYS.INTL
A calendar with no working weekdays
=NETWORKDAYS.INTL(A2,B2,C2)NETWORKDAYS.INTL returns zero for a seven-character all-closed mask, even though this interval includes a leap day. WORKDAY.INTL cannot advance on such a calendar and has a different validity rule.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
NETWORKDAYS.INTL · top-level call
=NETWORKDAYS.INTL(A2,B2,C2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.