Hi I've tried to adapt the standard Employee Absence Schedule excel template and need a little help.

I've added a worksheet with total holiday days. I need the Holiday Days column to add up full(1) and half days(0.5) then subtract the figure form the days left (total holiday days worksheet). Sick days just need to add up sick days for the month. Unpaid absence just needs to add up unpaid absence days for the month. The holiday remaining column just needs to subtract the holiday days from the days left column.

I hope this all makes sense - Any help would be much appreciated.

Employee absence schedule-help.xlsx