Hi. I am trying to calculate the number of workdays between 2 dates. I have a table on a different sheet showing my complete project calendar differentiating between Workdays, Non-Workdays and Holidays (see below):
Any ideas on how I should structure the formula so that the calculation between the two dates exclude the non-working and holiday dates obtained from the above table.
Help Article Resources
Check out the Formula Handbook template!