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 Reply

VBA Comment Structure

This section of the VBA learning course reviews the Comment Structure. In every programming language, you need to have the

Read More »

What is VBA in Excel?

VBA VBA, which stands for Visual Basic for Application, is a programming language developed to work with Microsoft’s Office applications

Read More »

CONCAT Function

The Excel CONCAT Function joins a range of cells or individual strings of data. This function was introduced in 2016

Read More »
Scroll to Top