Skip to main content

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 by N or date values, as returned by DATEDATEVALUE or TO_DATE. Values specified by a range should be standard date values or date serial numbers.

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 as NETWORKDAYS(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, use WORKDAY.

  • NETWORKDAYS works similarly to NETWORKDAYS.INTL but only treats Saturday and Sunday as the weekend. Use NETWORKDAYS.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
Date
US Holidays
2
1/1/2013
New Year's Day
3
1/21/2013
Birthday of Martin Luther King, Jr.
4
2/18/2013
Washington's Birthday
5
5/27/2013
Memorial Day
6
7
start_date
end_date
Result
8
1/1/2013
2/1/2013
NETWORKDAYS(A8,B8)
9
1/1/2013
2/1/2013
NETWORKDAYS(A9,B9,A2:A5)
D
1
2
3
4
5
6
7
Formula
8
24
9
22

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.