Introduction to NETWORKDAYS.INTL Function
NETWORKDAYS.INTL Function returns the count of days between the start date and end date. Unlike NETWORKDAYS, NETWORKDAYS.INTL lets you specify which days you want to exclude from the calculation.
Download Sample File
Download Sample Files to work, practice and master the Date Functions in Excel.
Syntax of NETWORKDAYS.INTL Function
NETWORKDAYS.INTL(start_date,end_date,weekend,holidays)
Arguments of NETWORKDAYS.INTL Function
- start_date: A valid date from where you want to start your calculation.
- end_date: A valid date up to which you want to calculate working days.
- [weekend]: A number represents to exclude weekends from the calculation.
- [holidays]: A list of dates that represents the holidays you want to exclude from the calculation.
Example of NETWORKDAYS.INTL Function in MS Excel
In the below example, we have used 01-Jan-2015 as a start date and 20-Jan-2015 as an end date. And we have specified 1 to take Sunday – Saturday as the weekend. The function has returned 14 days after excluding 6 weekend days.
Below, we have used the same dates. And I have used 11 in for weekend days which means it will only consider Sunday as a weekend. Along with that, we have also used 10-Jan-2015 as a holiday.
We have 3 Sundays between both dates and a holiday. After excluding all these days the function has returned 16 days in the result. Here in the below example, we have used range to specify holidays. If you have more than one date for the holidays you can refer to an entire range.
Quick Tip: If you want to create a dynamic range for holidays, you can use a table for that. If you want to choose custom days to count as working days or weekends, you can use the below format in the weekend argument.
Here, (zero) 0 represents a working day and 1 represents a non-working day. And, seven numbers represent 7 days of the week.
Other Excel Date Functions Tutorials
You can explore and master other date functions in Microsoft Excel. Here is a complete list of date functions available in Microsoft Excel.
