Learn Blog Pricing About Sign in

Learn

Blog

Pricing

About

Sign in

NETWORKDAYS.INTL function

NETWORKDAYS.INTL(Date1, Date2, Weekend?, Holidays?) NETWORKDAYS.INTL(Date1; Date2; Weekend?; Holidays?)

Date1

Number or { Number }

The first date, as a sequential serial number.

Date2

Number or { Number }

The second date, as a sequential serial number.

Weekend

Number or { Number } (optional)

A number specifying the day or days of the week that are considered weekend days. Refer to the table for more information on this parameter. If omitted, Saturday and Sunday are considered weekend days.

Holidays

{ Number } (optional)

An array of sequential serial numbers representing holidays, which are not considered working days. If omitted, only weekends are excluded from the calculation.

Returns

Number or { Number }

The number of working days between the given two dates.

Returns the number of working days between two dates. Weekends are excluded from the calculation, as are the holidays given as the third parameter.

The day or days of the week that are considered weekend days can be customized by specifying the weekend parameter. Use this table to determine what number to use:

Valid values for the Weekend parameter
Value Meaning
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

Examples

NETWORKDAYS.INTL(DATE(2008, 1, 1), DATE(2009, 1, 1))NETWORKDAYS.INTL(DATE(2008; 1; 1); DATE(2009; 1; 1))

Returns 263, the number of working days between January 1, 2008, and January 1, 2009. Saturdays and Sundays are considered weekend days, due to the third parameter.

NETWORKDAYS.INTL(DATE(2008, 1, 1), DATE(2009, 1, 1), 1, { DATE(2008, 5, 1) })NETWORKDAYS.INTL(DATE(2008; 1; 1); DATE(2009; 1; 1); 1; { DATE(2008; 5; 1) })

Returns 262, the number of working days between January 1, 2008, and January 1, 2009, when May 1, 2008, is explicitly excluded from the calculation. Saturdays and Sundays are considered weekend days, due to the third parameter.

NETWORKDAYS.INTL(DATE(2008, 1, 1), DATE(2009, 1, 1), 11, { DATE(2008, 5, 1) })NETWORKDAYS.INTL(DATE(2008; 1; 1); DATE(2009; 1; 1); 11; { DATE(2008; 5; 1) })

Returns 314, the number of working days between January 1, 2008, and January 1, 2009, when May 1, 2008, is explicitly excluded from the calculation. Only Sundays are considered weekend days, due to the third parameter.