Attendance of employee

There is data of attendance of Employee in Excel…
I want to count Present days, absent,Paid Leave,Pay days…
But with condition if employee is absent where the yesterday is weekend or holiday…then holiday or weekend treat as absent…
And same as tommorow…
From above file i want Like…Monthly_DetailedReportForEmployee.xls (11.5 KB)
In the Excel file…