IF Forumla Excluding Workdays & Holidays

Hi All,

I have loads being delivered on a certain day (Column B) and the proof of delivery submission on a separate date (Column C). I have to calculate the days between delivery and proof of delivery submission (Column D), but want to exclude weekends and holidays in the calculation.

In the attached example, I am using the following function to calculate the days between delivery and proof of delivery submission:

=IF(B2="","",IF(C2=""," ",IF(C2-B2>=0,C2-B2,"")))

How do I incorporate the "=WORKDAY" function to exclude weekends and holidays?

Your help is greatly appreciated.

Thank you!

It would be NetworkDays, not Worday.

Try

=IF(B2="","",IF(C2=""," ",IF(C2-B2>=0,NETWORKDAYS(B2,C2,$G$2),"")))

Originally Posted by Jonmo1

It would be NetworkDays, not Worday.

Try

=IF(B2="","",IF(C2=""," ",IF(C2-B2>=0,NETWORKDAYS(B2,C2,$G$2),"")))

Awesome! Thank you , Jonmo1

You're welcome.