Returns the number of net working days between two provided days.
Sample Usage
NETWORKDAYS(DATE(1969,7,16),DATE(1969,7,24))
NETWORKDAYS(A2,B2)
NETWORKDAYS(40909,40924)
NETWORKDAYS(40900,40950,{40909,40924})
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.
Notes
-
NETWORKDAYS
does not autoconvert number formats in the same way that Google Sheets 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 end date after a specified number of working days.
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 year, month, and day into a date.
Examples
Returns the number of workdays between the start_date
and end_date
(based on the given list of holidays).