Templates › Attendance Sheet
Attendance Sheet Excel Template
Mark P, A, L or H for each day of the month. Present, absent and leave days are counted for every person.
⬇ Download free (.xlsx)Free · No sign-up · 19 KB · Works in Excel and Google Sheets
See it filled with data
The file has two sheets: a blank one for your own data, and this filled Example so you can see how it works.
What is inside
- 31 day columns with a P / A / L / H drop-down
- Present, Absent and Leave counted for each person (COUNTIF)
- Name column stays in place when you scroll
- Ready for 50 people
How to use it
- Type the names in column A.
- Each day, pick P (present), A (absent), L (leave) or H (holiday).
- Read the three count columns at the end of the month.
- Use a new copy for each month.
Formulas used: COUNTIF COUNTA IF
⬇ Download the Attendance Sheet template
More free templates
InvoiceQuotationPayment TrackerExpense TrackerMonthly BudgetSales TrackerStock InventorySalary SheetTask TrackerLead TrackerLoan EMI Calculator
