Navigation:  Formula Reference > Spreadsheet Formula Functions >

NETWORKDAYS.INTL

Previous pageReturn to chapter overviewNext page

 

This function returns the total number of complete working days between the start and end dates.

Syntax

NETWORKDAYS.INTL(startdate,enddate,weekend,holidays)

Arguments

This function has these arguments:

Argument

Description

startdate

Date that is the starting date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)

enddate

Date that is the ending date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)

weekend

[Optional] A number or string that specifies when weekends occur. Weekend days are days of the week that are not included in the number of whole working days between startdate and enddate

holidays

[Optional] Range of dates to exclude from the calculation. Holidays can be a range of cells that contain the dates, or an array constant of the serial values that represent those dates

The following table lists the weekend number values:

Number

Day

1 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

Remarks

Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday. A non-workday is 1 and a workday is 0. Only characters 1 and 0 are allowed in the string. The string 1111111 always returns 0.

Weekend days and holidays are not considered to be workdays.

Data Types

Accepts numeric, string, or DateTime object data. Returns numeric data.

Examples

NETWORKDAYS.INTL(L4,L5)

NETWORKDAYS.INTL(R4C12,R1C1,R2C2)

NETWORKDAYS.INTL(DATE(2014,9,1),DATE(2014,9,30),\"0000111\",{\"2014/9/2\",\"2014/9/3\"}) gives the result 16