NetWorkdays

Description of formula:
Counts work days between two days, holidays can be excluded
Syntax:
NETWORKDAYS(from, to, holidays)
Parameters:
from (Date)
From date
to (Date)
To date
holidays (Date)
Array of dates that are holidays and should be excluded from calculation
Returned type:
Number
examples:
=networkdays(date(2016,1,1,1,1), date(2017,1,1,1,1))
=networkdays(date(2016,1,1,1,1), date(2017,1,1,1,1), A1:A6)
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk