NETWORKDAYS.INTL

Excel Functions

Get work days between two dates

Syntax

EXCEL

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Arguments

Parameter	Description
`start_date`	The start date.
`end_date`	The end date.
`weekend`	[optional] Setting for which days of the week should be considered weekends.
`holidays`	[optional] A reference to dates that should be considered non-work days.

Return Value

A number representing days.

Details

The NETWORKDAYS.INTL function returns the number of working days between two dates, taking into account holidays and weekends. This function is more robust than the NETWORKDAYS function because it allows you to control which days of the week are considered weekends. NETWORKDAYS.INTL takes four arguments: start_date, end_date, weekend, and holidays. The start_date, end_date and holidays arguments must be valid Excel dates. The weekend argument controls which days of the week are considered weekends, and therefore not included in the count. Holidays are also treated as non-working days and will not be included in the result. Both the weekend and holidays arguments are optional. By default, NETWORKDAYS.INTL will exclude Saturdays and Sundays, but this can be customized as explained below. To

Examples

In the example shown, the following formulas are used:

EXCEL

=NETWORKDAYS.INTL(B5,C5) // result 1, default
=NETWORKDAYS.INTL(B5,C5,1,holidays) // result 2, exclude holidays
=NETWORKDAYS.INTL(B5,C5,"1000000") // result 3, Monday is weekend

Configuring weekends

The second way to configure weekends is to provide a text string composed of 1s and 0s. This text is provided as a string of 7 characters which must b

EXCEL

NETWORKDAYS.INTL(start,end,"0101011") // workdays = M,W,F
NETWORKDAYS.INTL(start,end,"1010111") // workdays = Tue, Thu
NETWORKDAYS.INTL(start,end,"1111100") // workdays = Sat,Sun
NETWORKDAYS.INTL(start,end,"0000000") // all workdays, no weekends

NETWORKDAYS.INTL

Syntax

Arguments

Return Value

Details

Examples

See Also