Hello,
I have the following formula in E2 to calculate the number of days between two dates: =DATEDIF(C2,D2,"D"). However, I want to include the WORKDAY function along with a set of holidays to not calculate. The holidays are in F2:F4. I believe this is what I need in order for cell E2 to calculate only business days, excluding the holidays I have listed.
Thank you.
I have the following formula in E2 to calculate the number of days between two dates: =DATEDIF(C2,D2,"D"). However, I want to include the WORKDAY function along with a set of holidays to not calculate. The holidays are in F2:F4. I believe this is what I need in order for cell E2 to calculate only business days, excluding the holidays I have listed.
Thank you.