NETWORKDAYS.INTL
Formulas / NETWORKDAYS.INTLCalculate 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.
Frequently Asked Questions
What is the NETWORKDAYS.INTL function?
The NETWORKDAYS.INTL function calculates whole workdays between two dates.
Do I need to include holidays in the NETWORKDAYS.INTL function?
No, the holidays argument is optional.
What is the best way to enter a date into the NETWORKDAYS.INTL function?
The DATE function should be used to enter a date.
How does Sourcetable calculate dates?
Sourcetable calculates dates as sequential serial numbers. By default, January 1, 1900 is serial number 1.
