If Error ?

[bigjexcel]

In this workbook , the weekends highlighted in red are not being calculated , the holidays tab has some sort of functionality that prevents holidays listed there from being calculated as well. I don't mind the holidays not being calculated ,but I have employees that work weekends , so I am trying to figure out how add them back into the calculations. They have used a networkdays function some how You can see by the cells marked in green in the calendar table that the Jan 7 is not being calculated or I would have a 4.25 in the calculation box at the bottom. I am a total newb at this , and this is a free template I have found online through the excel templates that I am trying to modify .. any help is appreciated.

 

[bigjexcel]

I found this function , but i am unsure how to make it work exactly ... [FONT=&quot]=NETWORKDAYS.INTL([@[Start Date]],[@[End Date]],7,lstHolidays) .. there is something similar already in the formula bar , i am thinking this statement is governing whether or not the weekend day is being calculated as a day off . [/FONT]