Attendance Tracker Excel Template | Employee & Class Attendance with Percentage

Know everyone's attendance percentage without counting a single box.

An attendance tracker Excel template for a team or a class: mark each day with a one-letter code and the sheet counts present, absent, late, sick and vacation days and shows each person's attendance percentage for the month and the year.

WHAT'S INCLUDED• 12 monthly sheets (Jan-Dec 2027) for up to 40 people, 31 day columns with drop-down codes• Codes: P present, A absent, L late, S sick, V vacation, H holiday, WFH work from home• Automatic totals and attendance % per person; weekends shaded, below-90% highlighted in red• Year Summary: every person's totals and attendance % for the whole year• Dashboard: people, average attendance, days absent, late days, sick days, 100% attendance count + 2 charts• Setup sheet for names, department or class, start date; Start Here guide and sample data

BEST FORSmall business owners, managers, HR, teachers, tutors, coaches and club organisers who need a simple attendance register with percentages.

HOW IT WORKS1. Type your names on Setup.2. Mark each day on the month sheet.3. Read the % on Year Summary and Dashboard.

PAIRS WELL WITHOther LaunchKit Labs Excel templates at mahmoudian113.gumroad.com

FORMAT / DELIVERYMicrosoft Excel .xlsx file (no macros) - also opens in Google Sheets. Instant digital download, no physical item.

FAQ

What exactly do I get?

Attendance tracker Excel template: 12 monthly sheets for 40 people, P/A/L/S/V codes, attendance % per person, year summary and dashboard.

What do I need to use it?

Microsoft Excel on Windows or Mac (Excel 2016 or newer, or Microsoft 365). It also opens in free Google Sheets, though Excel is recommended.

How do I get it?

It is an instant digital download: right after payment you get the file on the page and by email. No physical item is shipped.

What if it is not right for me?

Contact me through my Payhip store within 30 days and I will refund you - no hard feelings.

I have a question

Use the contact link on my Payhip store page and I will help.