Table of Contents
About
NETWORKDAYS.INTL function in Excel can be used to find the number of working days between two dates. By default, NETWORKDAYS.INTL excludes Saturday and Sunday from the working calendar along with the dates supplied as holidays. The main difference between NETWORKDAYS and NETWORKDAYS.INTL function is that the latter has the option to define custom weekends.
Function Type
Date and time
Purpose
Get the number of working days between two dates.
Return value
A number representing working days.
Syntax
=NETWORKDAYS.INTL(start_date,end_date,[weekend],[holidays])
Arguments
start_date – A valid excel date that represents the start date.
end_date – A valid excel date that represents the end date.
weekend – [optional] The number that represent a weekends. The table given below has the codes allowed for this argument and the weekend days corresponding to each code.
holidays – [optional] Dates to exclude from the working calendar.
| Weekend Number | Weekend Days |
|---|---|
| 1 (default) | Saturday, Sunday |
| 2 | Sunday, Monday |
| 3 | Monday, Tuesday |
| 4 | Tuesday, Wednesday |
| 5 | Wednesday, Thursday |
| 6 | Thursday, Friday |
| 7 | Friday, Saturday |
| 11 | Sunday only |
| 12 | Monday only |
| 13 | Tuesday only |
| 14 | Wednesday only |
| 15 | Thursday only |
| 16 | Friday only |
| 17 | Saturday only |
Example
Notes
NETWORKDAYS.INTL will consider both the start date and end date as work days. If the same date is used as start date and end date, NETWORKDAYS.INTL function will return 1, provided the date is not a holiday.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)