I know of a formula that can calculate # workdays overlapping between 2 date ranges... but i need this per person for multiple date ranges, and i'm not sure how to wrap my head around it.
Formula for # workdays between 2 date ranges:
=MAX(0,NETWORKDAYS(MAX(E2,E3),MIN(F2,F3),L_Holidays))
I have attached an example of 2 tables, one is "PTO" the other is "Projects". On the projects side of the table i need a formula that can detect the person responsible for the project, and look through that persons PTO on the PTO table, then count the number of overlapping days between the start and end date of the project and all of the start and end dates of any applicable PTO.
Thanks much for your help!
Bookmarks