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.
Category: Date and time
Returns the number of whole workdays between two dates
NETWORKDAYS(start_date, end_date, [holidays])
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM