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:

image2016-7-19 17:59:30.png

By adding the values you would like to calculate, Excellentable generates the outcome:

image2016-7-19 18:0:3.png