Employee Attendance Record

I found this great template for tracking employees attendance.
My challenge is that the wonderful formula does one thing that I don't want it to do - that is; it does not calculate weekends and holidays. Some of our team work holidays and weekends and they take off for holidays and weekends. How to tell it to count all of the days and subtract them only when they are taken by an employee. I love this set up, it is awesome. I love formulas, but this is above my skills. Thanks for your help.

Please find a copies attached - one is Excel 2007 and one is Excel lower version.

No personal data included - names included but information is made up.