The Employee Attendance Tracker records each person's days in a monthly grid, using the codes P for present, A for absent, L for leave and S for sick. The Absences tab logs each absence with a reason and an approval tick. The Dashboard counts absence entries by code and by person, and shows how many are waiting for approval.

It comes with sample data for the first week of November and a short list of absences. Make a copy and replace the sample rows. The formulas and charts update on their own.