NETWORKDAYS (start date
start date is the date from when the calculation is carried out. If the day is a workday, it is included in the calculation.
end date is the date up until when the calculation is carried out. If the day is a workday, it is included in the calculation.
holidays is an optional list of nonworking days. Enter a cell range in which the holidays are listed individually.
To determine how many workdays fall between 12/15/2001 and 1/15/2002, use the start date that is located in C3 and the end date in D3. Cells F3 to J3 contain the following Christmas and New Year holidays: "12/24/2001", "12/25/2001", "12/26/2001", "12/31/2001", "1/1/2002".
to return 17
Parent topic: Date and time functions