Excel NETWORKDAYS() function

Last update on August 19 2022 21:50:34 (UTC/GMT +8 hours)

NETWORKDAYS() function

This function is used to return the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.

Version: Excel 2013

Syntax:

NETWORKDAYS(start_date, end_date, [holidays])

Parameters:

Name	Description	Data Type	Required/ Optional
Start_date	A date that represents the start date.	Date	Required
End_date	A date that represents the end date.	Date	Required
Holidays	An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant of the serial numbers that represent the dates.	Date	Optional.

Remarks:

Microsoft Excel stores date as sequential serial numbers so they can be used in calculations. By default, January 1, 1900, is serial number 1, and January 1, 2012, is serial number 40909 because it is 40,908 days after January 1, 1900.
If any argument is not a valid date, NETWORKDAYS returns the #VALUE! error value.

Example - 1:

The example below finds the number of workdays between the start (10/10/2012) and end date (12/10/2013).

Example - 2:

The example below finds the number of workdays between the start (10/12/2012) and end date 10/12/2013), with the 04/15/2013 holiday as a non-working day.

Example - 3:

The example below finds the number of workdays between the start (10/12/2012) and end date (10/12/2013), with the two holidays as non-working days.

Previous: Excel MONTH() function
Next: Excel NETWORKDAYS.INTL() function