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
Count workdays while excluding a named holiday
=NETWORKDAYS.INTL(A2,B2,"0000011",C2)The seven-character mask runs Monday through Sunday; 1 marks a weekend day. Friday and Tuesday count, Saturday/Sunday do not, and the Monday holiday is excluded. Endpoints are included when they qualify.
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,"0000011",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.