What’s in this attendance sheet template
This free attendance sheet is a classic monthly register (also called a muster roll or attendance register format): one row per person and one column for each day of the month. It’s built for small businesses, HR teams, schools, coaching centres, and anyone tracking attendance in Excel.
- Every day of the month with its weekday, for any month and year you choose.
- Weekly offs shaded (Sunday, Saturday and Sunday, Friday, or Friday and Saturday) and optionally pre-filled with W.
- Automatic totals for Present, Late, Half day, Leave and Absent on every row.
- Attendance percentage for each person, calculated only from working days.
- Up to 300 rows, labelled for employees, students, staff or members.
- A printable version that fits one month on a landscape page.
How to use this attendance sheet
- Choose the month and weekly off. Pick the month and your weekly off days. Day numbers, weekdays and shaded weekly offs fill in automatically.
- Download or print the sheet. Download the Excel file with built-in formulas, or print a landscape sheet to fill in by hand.
- Add names. Write one employee or student name per row in the Name column.
- Mark attendance every day. Enter a code in each day cell: P present, A absent, L leave, LT late, HD half day, H holiday, W weekly off.
- Read the totals and attendance %. In Excel the totals and attendance percentage update as you type. On paper, count the codes at month end.
At month end, upload the finished sheet to the free attendance report generator to see everyone’s attendance percentage, who is below 75% and your lowest-attendance days, in seconds.
Attendance codes used in the sheet
Using the same short codes every day keeps totals accurate and makes the sheet easy to read at a glance.
| Code | Meaning | Counts towards attendance % |
|---|---|---|
| P | Present | Yes, as a full day present |
| LT | Late | Yes, as present (tracked separately) |
| HD | Half day | Yes, as half a day present |
| L | Leave (sick, casual, annual) | Counted as a working day missed |
| A | Absent | Counted as a working day missed |
| H | Public holiday | No, not a working day |
| W | Weekly off | No, not a working day |
Excel formulas used in the template
Each row counts its codes with COUNTIF and then works out attendance percentage. For a row where the days are in columns C to AG:
COUNTIF ignores upper and lower case, so “p” and “P” both count. For the maths behind the percentage, or to check a single person, use the attendance percentage calculator.
Daily, monthly or yearly attendance sheet?
A daily attendance sheet is a single sign-in list for one day, which suits events and training sessions. A monthly attendance sheet, like this one, is the most common format for employees and classes because it lines up with payroll and monthly reports. A yearly attendance sheet is usually a summary of the twelve monthly totals. The easiest way to build one is to keep each month’s sheet as a tab in one workbook.
Employee attendance sheet vs student attendance register
The layout is the same. For an employee attendance sheet, you’ll usually track leave and late arrivals and use the totals for payroll. For a student attendance register, the attendance percentage matters most, often against a 75% minimum, so leave is typically counted as a day missed.
Tips for keeping an accurate attendance register
- Mark attendance at the same time every day. Filling it in from memory at month end is where most errors come from.
- Use the same codes all year. Mixing ✓, P and 1 makes totals unreliable.
- Mark holidays as H instead of leaving them blank, so a blank always means “not marked yet”.
- Keep past months. Many labour laws require attendance records to be kept for several years.
- Tired of chasing sign-ins? Clocked Live lets your team check in from their phones and keeps this register for you automatically.