NETWORKDAYS(...)
Find working days between two dates
Used Functions
Category: Date and time
Returns the number of whole workdays between two dates
Syntax
NETWORKDAYS(start_date, end_date, [holidays])
Practice NETWORKDAYS Formula at Sheetzoom
NETWORKDAYS formula at Microsoft help
0
MS Excel has a built-in function of NETWROKDAYS() that can be used to calculate the number of working days. It takes date range and the holidays as arguments to give the final answer.