# NETWORKDAYS.INTL

Returns the number of net working days between two provided dates, excluding specified weekend days and holidays.

### Sample Usage

NETWORKDAYS.INTL(DATE(1969,7,16),DATE(1969,7,24))
NETWORKDAYS.INTL(C5,C6,1,A1:A10)

### Syntax

NETWORKDAYS.INTL(start_date, end_date, [weekends], [holidays])

• start_date - The date from which the calculation is carried out.
• end_date - The date up to which the calculation is carried out.
• weekends - [OPTIONAL] A string or number representing which days of the week are considered weekends.
• Weekends can be specified using a string comprising of 0’s and 1’s, where a zero means that the day is a work day, and a 1 means that the day is a weekend. The first number in the set represents Monday. So, “0000011” would mean Saturday and Sunday are weekends.
• You can also specify the weekend pattern using a single number.
• 1 = Saturday and Sunday are weekends
• 2 = Sunday and Monday are weekends and so on until
• 7 = Friday and Saturday are weekends.
• 11 = Sunday is the only weekend
• 12 = Monday is the only weekend and so on until
• 17 = Saturday is the only weekend.
• holidays - [OPTIONAL] A cell range containing the list of holidays.

### Examples

NETWORKDAYS.INTL(DATE(1969,7,16),DATE(1969,7,24)) returns the number of workdays between the mentioned dates, which is 7.
NETWORKDAYS.INTL(C5,C6,2,A1:A10) returns the number of workdays between the mentioned dates, excluding Saturdays, Sundays and holidays specified in A1:A10

### Notes

• NETWORKDAYS.INTL does not auto-convert number formats. Therefore, NETWORKDAYS.INTL(10/10/2000) is interpreted as NETWORKDAYS.INTL(0.05) , the quotient of 10 divided by 10 divided by 2000.
• NETWORKDAYS.INTL is similar to NETWORKDAYS, but it allows weekend days to be specified for areas where Saturday and Sunday are not considered the weekend.
• NETWORKDAYS.INTL 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.INTL.