Please enable JavaScript to view the comments powered by Disqus.


NETWORKDAYS(...B3,B4,B5:B6)

Find working days between two dates

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.


Used Functions

Category: Date and time

Returns the number of whole workdays between two dates

Syntax

NETWORKDAYS(start_date, end_date, [holidays])

Lets chat on this