How to Make an Attendance Sheet in Excel: Monthly Tracker With Formulas
- Tahir Abbas
- November 18, 2026
An attendance sheet records who was present, absent or on leave on each day, and calculates totals and percentages for you. Teachers, managers and small business owners use it for classes, shifts and projects. In Excel you can build one in under an hour: a row of dates across the top, a list of names

