Please enable JavaScript to view the comments powered by Disqus.


Using NETWORKDAYS formula

The formula needs three arguments, first and the second are starting and the end date, the third one is an optional argument and it takes date range of holidays from the worksheet, thus returning the result.

Used Functions

Category: Date and time

Returns the number of whole workdays between two dates


NETWORKDAYS(start_date, end_date, [holidays])

Lets chat on this