The NETWORKDAYS.INTL Function calculates the number of workdays between two given dates. This function is used as a business day calculator. Weekend days are able to be specified. The table is outlined below.
Syntax:
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Arguments:
- start_date – (required) Can be earlier than the end_date, later than end_date, or same as end_date.
- end_date – (required) The end date
- [weekend] – (optional) If omitted, the default weekend will be Saturday & Sunday. See the table below Fig 1.1
- [holidays] – (optional) Holiday’s are specified. They can be a single cell or an array of cells. There are no default holiday’s in Excel
Fig. 1.1
Weekend Number | Weekend Days |
0 or omitted | 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 |
NETWORKDAYS.INTL Function Example
Let’s start with the example below. Our start date is 4/2/2019 and our end date is 12/15/2019. Start by entering the following formula in cell C8.
=NETWORKDAYS.INTL(B4,C4,1,G4:G6)
For the [weekend] argument, we entered 1 for Saturday,Sunday.
Ensure that the holiday’s are selected in cells G4-G6. These have to be specified individually. Excel does not have any default holidays.
Finally, the formula returns the number of working days, 182, between our two dates.
Common Errors
- #VALUE! Error – When the weekend string contains invalid character.
- Negative Value – If the end date is before the start date, you will get a negative number. You can use the ABS Function to fix this.