A to Z of Excel Functions: the NETWORKDAYS Function
7 November 2022
Welcome back to our regular A to Z of Excel Functions blog. Today we look at the NETWORKDAYS function.
The NETWORKDAYS function
Workdays typically include Monday to Friday, excluding any holidays. However, holidays may differ depending upon the region of the world you live in.
The NETWORKDAYS function returns the number of whole working days between a start date and an end date. This excludes weekends by default and may also except a custom list of dates to account for regional holidays. This can be used to calculate employee benefits the accrue based upon the number of days worked during a specific term.
The NETWORKDAYS function employs the following syntax to operate:
NETWORKDAYS(start_date, end_date, holidays)
The NETWORKDAYS function has the following arguments:
- start_date: this is required and is a date representing the start of the period
- end_date: this is also required. This is a date representing the end of the period
- holidays: this is optional. This represents an optional range of one or more dates to be excluded from the working calendar. This list can be either a range of cells containing the dates or an array constant of serial numbers representing the dates.
It should be further noted that:
- dates should be entered by using the DATE function, or as results of other formulas or functions. For example, use DATE(2012,5,23) for the 23rd day of May, 2012. Problems can occur if dates are entered as text
- Excel stores dates 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.
Please see my example below:
As you can see above, the function may be used to calculate the number of non-weekend days in a period, potentially excluding a custom list of holidays too.
We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every other business day.