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?
Click to expand...

=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

Similar Threads

Calculate next workday after adding calendar days to date in cell 13
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Calculate the number of days to exclude Sunday & Holidays 6
Consecutive date calculation involving holidays 1
Help using the Workday Function 1
Alternative formula to exclude holiday calculation 6
Adding days to the WORKDAY function 2
workday calendar 1

Top