# NETWORKDAYS.INTL

Formulas / NETWORKDAYS.INTL
Calculate the number of working days between two dates.
`=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])`
• start_date - required argument that is the start date
• end_date - required argument that is the end date
• weekend - [OPTIONAL] argument that sets which days of the week are considered weekends
• holidays - [OPTIONAL] argument that sets which days of the year are considered holidays

## Examples

• `=NETWORKDAYS.INTL(B5,C5)`

The NETWORKDAYS.INTL function can be used to calculate the number of workdays (Monday through Friday) between two dates use the formula above. This will return the number of workdays between the two dates in cells B5 and C5, with weekends being the default.

• `=NETWORKDAYS.INTL(B5,C5,1,holidays)`

If you have a list of holidays or any other dates you would like to exclude from the calculation use this formula. This will return the number of workdays, excluding any dates from the list of holidays.

• `=NETWORKDAYS.INTL(B5,C5,"1000000")`

This will return the number of workdays between the two dates, with Monday as the weekend day instead.

## Summary

The NETWORKDAYS.INTL function is used to calculate the number of days between two dates. It was introduced in Excel 2010 and is a date/time function.

• The NETWORKDAYS.INTL function takes four arguments - start_date, end_date, weekend and holidays. The weekend and holidays arguments are both optional.
• The weekends argument controls which days of the week are considered weekend days.
• The holidays argument is optional and allows you to specify which dates should be excluded from the calculation.