Attendance Generator
Monthly attendance sheets with automatic totals.
Generate a month-by-month attendance register with weekends and holidays pre-marked, dropdown status codes, and automatic per-employee totals for present, absent, leave and late days.
- Rating
- 4.8(1.2K)
- Monthly uses
- 164K
- Price
- Free
or drag it here
· processed locally, never uploaded
Files stay on your device
What it does well
- Weekends and holidays shaded automatically for the month you pick
- Status dropdowns with counts per code per employee
- Twelve-month workbook option with a yearly summary sheet
How to use Attendance Generator
- 1
Choose the month, year and working days.
- 2
Add your employee list.
- 3
Mark public holidays on the calendar.
- 4
Download the attendance workbook.
Watch a walkthrough
Common problems and fixes
Totals do not change when I mark attendance.
You typed a code that is not in the dropdown list. Use the dropdown, or add your custom code to the codes sheet.
Weekend shading is on the wrong days.
The week start setting does not match your region. Change it before generating — it drives the whole calendar layout.
Frequently asked questions
What people say
Small thing, but the error messages actually tell you what to fix. Attendance Generator flagged a hidden character that had been breaking my lookups for weeks.
Exactly what I needed. Attendance Generator used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
Exactly what I needed. Attendance Generator used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
More templates tools
Invoices, payroll, timesheets, budgets and dashboards — every template ships with real formulas, not screenshots, and downloads as a native .xlsx.
Browse Templates