Calculate the number of workdays between 2 dates

T

Tegid77

Dave R.
Thanks for the quick help, that did the trick! Do you know if there i
a way to have it not count holidays also? If so can you enter in
custom holiday calendar
 
A

Aladin Akyurek

Tegid77 said:
Dave R.
Thanks for the quick help, that did the trick! Do you know if there i
a way to have it not count holidays also? If so can you enter in
custom holiday calendar?

=NETWORKDAYS(Date1,Date2,Holidays)

where Holidays refers to a range housing known holiday dates
 
Top