A monthly attendance sheet, free.
A one-month register for up to 20 people. Pick P, L, A or E for each day, and attendance % is worked out for everyone, with anyone under 90% in red.
✓ 100% free ✓ Instant download ✓ Excel for Windows & Mac
| Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | % |
|---|---|---|---|---|---|---|---|---|---|---|
| Ava Johnson | P | P | P | P | P | L | A | 95% | ||
| Liam Smith | P | P | P | L | P | P | P | 100% | ||
| Noah Davis | P | P | A | P | P | L | P | 77% | ||
| Emma Wilson | P | P | P | P | L | P | P | 100% | ||
| Mason Taylor | P | P | P | A | P | P | A | 86% |
Simple, and it does the counting
Colour-coded register
Present, Late, Absent and Excused, each in its own colour. Weekends are shaded.
Attendance worked out
Present days, absences and a % for every person, updated as you go.
Below 90% in red
Anyone under 90% attendance is flagged straight away.
Yours in under a minute
Click “Download it free”
You’ll go to a secure download page. There’s nothing to pay.
Enter your email
The download link is sent straight to your inbox, and you can download it straight away too.
Open it in Excel
Type the month and your names, then pick a code for each day.
Free version or full version
The free sheet covers one month. The full Attendance Tracker covers the whole year, with your own codes, target and a dashboard.
| Free | Full version · $9.99 | |
|---|---|---|
| Colour-coded register | ✓ | ✓ |
| Attendance % for each person | ✓ | ✓ |
| People | 20 | 40 |
| Months | 1 | 12 |
| Codes | 4 fixed | 8, your own |
| Half days and sick days | – | ✓ |
| Your own target with amber warnings | – | ✓ |
| Year summary | – | ✓ |
| Dashboard with chart | – | ✓ |
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials. This free sheet uses the COUNTIF and colour-coding formulas from my tutorials, ready to use today.
Questions
Is it really free?
Yes. You just enter your email address so the download link can be sent to you.
Will you email me?
Now and then, with new Excel templates and tips. You can unsubscribe at any time with one click.
Does it use macros?
No. It’s a normal .xlsx file, so there’s nothing to enable and no security warnings.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac.
Take this month’s register the easy way.
Download the free Monthly Attendance Sheet and let Excel do the counting.
Download it freeWant the whole year and a dashboard? See the full Attendance Tracker.