Sample usage
NETWORKDAYS.INTL(DATE(1969, 7, 16), DATE(1969, 7, 24), 1, A1:A10)
NETWORKDAYS.INTL(DATE(1969, 7, 16), DATE(1969, 7, 24))
NETWORKDAYS.INTL("12/04/1995", "12/22/1995", 3)
NETWORKDAYS.INTL("12/04/1995", "12/22/1995", “0000011”)
Syntax
NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
start_date
– The start date of the period from which the number of net working days is calculated.end_date
– The end date of the period from which the number of net working days is calculated.weekend
– [ OPTIONAL – 1 by default ] – A number or string representing which days of the week are considered weekends.- String method: Weekends can be specified using seven 0s and 1s, where the first number in the set represents Monday and the last number is for Sunday. A zero means that the day is a work day, a 1 means that the day is a weekend. For example, “0000011” would mean Saturday and Sunday are weekends.
- Number method: Instead of using the string method above, a single number can be used. 1 = Saturday/Sunday are weekends, 2 = Sunday/Monday and this pattern repeats until 7 = Friday/Saturday. 11 = Sunday is the only weekend day, 12 = Monday is the only weekend day and this pattern repeats until 17 = Saturday is the only weekend day.
holidays
– [ OPTIONAL ] – A range or array constant containing the dates to be considered as holidays.
Notes
-
NETWORKDAYS.INTL
does not auto-convert number formats in the same way that Google Sheets does upon direct entry into cells. Therefore,NETWORKDAYS.INTL(10/10/2000,10/10/2001)
is interpreted asNETWORKDAYS.INTL(0.005,0.00499750124938)
, the quotients of 10 divided by 10 divided by 2,000 and 2,001, respectively. -
NETWORKDAYS.INTL
calculates the number of working days between two dates. To calculate the working days a specific number of days ahead of a date, useWORKDAY.INTL
. NETWORKDAYS.INTL
works similarly to NETWORKDAYS but also allows weekend days to be specified (for areas where Saturday and Sunday are not considered the weekend).
See also
NETWORKDAYS
: Returns the number of net working days between two provided days.
WORKDAY.INTL
: Calculates the date after a specified number of working days, excluding specified weekend days and holidays.
EDATE
: Returns a date that is a specified number of months before or after another date.
EOMONTH
: Returns a date representing the last day of a month which falls a specified number of months before or after another date.
NOW
: Returns the current date and time as a date value.