NETWORKDAYS

Excel Functions

Get the number of working days between two dates

Syntax

EXCEL

=NETWORKDAYS(start_date, end_date, [holidays])

Arguments

Parameter	Description
`start_date`	The start date.
`end_date`	The end date.
`holidays`	[optional] A list of non-work days as dates.

Return Value

A number representing days.

Details

The NETWORKDAYS function returns the number of working days between two dates, automatically excluding weekends (Saturday and Sunday) and optionally excluding holidays provided as a list of dates. NETWORKDAYS can be used to calculate employee benefits that accrue based on days worked, the number of working days available during a project, the number of working days required to resolve a customer support issue, etc. NETWORKDAYS takes three arguments: start_date, end_date, and holidays. All three arguments must be valid Excel dates. Holidays are optional. To exclude holidays, provide a range of valid Excel dates for the holidays argument. Holidays are treated as non-working days and will not be included in the result. NETWORKDAYS includes both the start date and end date when calculating wor

Examples

Example

The general form of a NETWORKDAYS formula is as follows:

EXCEL

=NETWORKDAYS(start,end) // exclude weekends
=NETWORKDAYS(start,end,holidays) // exclude weekends + holidays

Example

In the example shown, holidays is the named range H5:H13, which contains non-working days in 2021. Columns E and F show the number of working days in

EXCEL

=NETWORKDAYS(B5,C5) // returns 21

Example

The formula in cell F5 (Result 2) does take into account holidays:

EXCEL

=NETWORKDAYS(B5,C5,holidays) // returns 19

NETWORKDAYS

Syntax

Arguments

Return Value

Details

Examples

See Also