NETWORKDAYS
Definition
Returns the number of net working days between two provided days.
Sample Usage
Syntax
NETWORKDAYS(start_date, end_date, [holidays])
start_date
- The start date of the period from which to calculate the number of net working days.end_date
- The end date of the period from which to calculate the number of net working days.holidays
- [ OPTIONAL ] - A range or array constant containing the date serial numbers to consider holidays.- The values provided within an array for
holidays
must be date serial number values, as returned byN
or date values, as returned byDATE
,DATEVALUE
orTO_DATE
. Values specified by a range should be standard date values or date serial numbers.
- The values provided within an array for
Notes
NETWORKDAYS
does not autoconvert number formats in the same way that Excellentable does upon direct entry into cells. Therefore,NETWORKDAYS(10/10/2000,10/10/2001)
is interpreted asNETWORKDAYS(0.005,0.00499750124938)
, the quotients of 10 divided by 10 divided by 2000 and 2001, respectively.NETWORKDAYS
calculates the number of work days between two dates. To calculate the working day a specific number of days ahead of a date, useWORKDAY
.NETWORKDAYS
works similarly toNETWORKDAYS.INTL
but only treats Saturday and Sunday as the weekend. UseNETWORKDAYS.INTL
to use other days of the week as the weekend.
See Also
NETWORKDAYS.INTL
: Returns the number of net working days between two provided days excluding specified weekend days and holidays.
WORKDAY
: Calculates the number of working days from a specified start date.
TO_DATE
: Converts a provided number to a date.
N
: Returns the argument provided as a number.
DATEVALUE
: Converts a provided date string in a known format to a date value.
DATE
: Converts a provided year, month, and day into a date.
In order to use the NETWORKDAYS formula, start with your edited Excellentable, Then type in the NETWORKDAYS Formula in the area you would like to display the outcome:
By adding the values you would like to calculate, Excellentable generates the outcome:
A
|
B
|
C
|
|
---|---|---|---|
1
|
|||
2
|
|||
3
|
|||
4
|
|||
5
|
|||
6
|
|||
7
|
|||
8
|
|||
9
|
|||
10
|
|||
11
|
|||
12
|
|||
13
|
|||
14
|
|||
15
|
D
|
E
|
F
|
G
|
|
---|---|---|---|---|
1
|
||||
2
|
||||
3
|
||||
4
|
||||
5
|
||||
6
|
||||
7
|
||||
8
|
||||
9
|
||||
10
|
||||
11
|
||||
12
|
||||
13
|
||||
14
|
||||
15
|