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.
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
- 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
|Weekend Number||Weekend Days|
|0 or omitted||Saturday, Sunday|
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.
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.
- #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.