Attendance Sheet (Excel)
A monthly attendance grid for up to thirty employees or students, with automatic counts and percentages.
Download the template
Download attendance-sheet.xlsx Excel workbook (.xlsx), 12 KB. Works in Microsoft Excel, LibreOffice Calc and Google Sheets.
What is inside
- Attendance: Employee rows by day 1 to 31 with weekday headers, and totals for present, absent, leave and attendance %.
Key columns and cells
- Month (C3): enter the first day of the month; weekdays update.
- Marks: P present, A absent, L leave, H half day (counts as half present and half absent).
- Working days (G3): used for the attendance percentage.
How to use it
- Replace the example employee.
- Set the month and the number of working days.
- Choose a mark for each day from the drop-down.
- Read the totals at the right of each row.
Notes and assumptions
- Days that do not exist in a month show no weekday label; leave them blank.
- Attendance % = present days divided by the working days you enter.
Frequently asked questions
Can I add Sundays or holidays?
Leave those cells blank or add your own mark and extend the formulas.
How many people can I track?
Thirty rows are provided.