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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top