sheetshelp.com - NETWORKDAYS.INTL function
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Start dateEnd dateWeekendsHolidaysResultFormula and explanation
2
3/4/164/1/1621=NETWORKDAYS.INTL(B2,C2) Plain and simple, no holidays.
3
3/21/172/8/202512/25/20172,058=NETWORKDAYS.INTL(B3,C3,1,E3) With one holiday and standard weekends.
4
3/21/172/8/2025001000012/25/20172,469=NETWORKDAYS.INTL(A4,B4,C4,D4) With only Wednesday as weekend.
5
Note that I had to place a ' before the 0010000 in cell C4 so that it was read as text.
6
8/23/18TOMORROW#VALUE!
=NETWORKDAYS.INTL(B6,C6) Error - One or more of the values is not a number.
7
8
Result
Formula and explanation
9
262
=NETWORKDAYSINTL(DATE(2017,2,3),DATE(2018,2,5)) - Using the date function.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...