- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
-
Formula Reference
- Formula Overview
-
Formula Functions
- Barcode Functions
- Compatibility Functions
- Database Functions
- Date and Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Logical Functions
- Lookup and Reference Functions
- Math and Trigonometric Functions
- Statistical Functions
- Sparkline Functions
- Text Functions
- Web Functions
- Other Functions
- RegEx Functions
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
NETWORKDAYS.INTL
This function returns the total number of complete working days between the start and end dates.
Syntax
NETWORKDAYS.INTL( startdate, enddate, weekend, holidays )
Arguments
This function has these arguments:
Argument | Description |
|---|---|
startdate | Date that is the starting date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4) |
enddate | Date that is the ending date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4) |
weekend | [Optional] A number or string that specifies when weekends occur. Weekend days are days of the week that are not included in the number of whole working days betweenstartdateandenddate |
holidays | [Optional] Range of dates to exclude from the calculation. Holidays can be a range of cells that contain the dates, or an array constant of the serial values that represent those dates |
The following table lists the weekend number values:
Number | Day |
|---|---|
1 or omitted | Saturday, Sunday |
2 | Sunday, Monday |
3 | Monday, Tuesday |
4 | Tuesday, Wednesday |
5 | Wednesday, Thursday |
6 | Thursday, Friday |
7 | Friday, Saturday |
11 | Sunday only |
12 | Monday only |
13 | Tuesday only |
14 | Wednesday only |
15 | Thursday only |
16 | Friday only |
17 | Saturday only |
Remarks
Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday. A non-workday is 1 and a workday is 0. Only characters 1 and 0 are allowed in the string. The string 1111111 always returns 0.
Weekend days and holidays are not considered to be workdays.
Data Types
Accepts numeric, string, or DateTime object data. Returns numeric data.
Examples
NETWORKDAYS.INTL(L4,L5)
NETWORKDAYS.INTL(R4C12,R1C1,R2C2)
NETWORKDAYS.INTL(DATE(2014,9,1),DATE(2014,9,30),"0000111",{"2014/9/2","2014/9/3"}) gives the result 16.