NETWORKDAYS.INTL Function

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 NumberWeekend 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.

NETWORKDAYS.INTL Example
Function Setup

Ensure that the holiday’s are selected in cells G4-G6. These have to be specified individually. Excel does not have any default holidays.

NETWORKDAYS.INTL Results
Results

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.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Send this to a friend