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.

Thanks so much but that one is a trial and will eventually cost. The one I am using is a free template that needs just a little bit adjusting to meet my needs. So far, I have four recommended to me, but I don't think anyone has actually looked at the one I am talking about. it is so awesome. Thanks again.

Actually, this can be done with a time tracking software such as Replicon and Time Doctor.
However, if you're still looking for more alternatives (such as those features you mentioned) I suggest you look at this editable list of over 10 time and attendance software http://biz30.timedoctor.com/list-of-...ance-software/

It compares the features, pricing, and software integration.