The NETWORKDAYS function calculates the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. For example, you could use this function to calculate employee benefits that accrue based on the number of days worked during a specific term.

NETWORKDAYS takes 2 required arguments and 1 optional argument:

Syntax: NETWORKDAYS(start_date, end_date, [holidays])

#1)
Using the NETWORKDAYS function:
#2)
The arguments for the NETWORKDAYS function are:
Argument Required? Description
start_date Required A date that represents the start date.
end_date Required A date that represents the end date.
holidays Optional 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.

Summary

The NETWORKDAYS function calculates the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays. For example, you could use this function to calculate employee benefits that accrue based on the number of days worked during a specific term.
comments powered by Disqus