31-day P/A/L/H/W grid with colour-coded cells; auto counts of present/absent/leave, attendance %, and a running leave balance against entitlement. Summary dashboard with average attendance and a day-type doughnut.

There is also a lightweight version of this template: Monthly Attendance Tracker · Free
Track a whole team's attendance in one sheet. Mark each day as Present, Absent, Leave, Holiday or Week Off and this free Attendance & Leave Tracker counts present, absent and leave days for every employee automatically, then works out each person's attendance percentage. Colour-coded cells make patterns easy to read across the month.
Set a leave entitlement per employee and the template keeps a running leave balance as leave is taken. A summary dashboard shows average attendance, total present, absent and leave days, and a day-type distribution chart. Built for Microsoft Excel 2016+, ready to use with sample staff.
Built from real-world business experience by the ExcelGurukul team. Tested across multiple industries and roles.
Yes, free download, no sign-up.
Yes, it subtracts leave taken from each employee's entitlement automatically.
It provides 31 day columns for any single month.