Automated Excel Attendance Tracker

I need a streamlined Excel file that lets me record everyone’s presence every day, flags late arrivals or absences automatically, and rolls everything up into a clean month-end report. Data entry should be hands-off: formulas, look-ups, or PivotTables do the heavy lifting once I drop in a basic roster.

Here’s what matters to me:
• Daily attendance registers itself the moment a time stamp appears.
• Late or missing punches are highlighted so I can spot issues at a glance.
• At month’s end I press a button— or refresh a Pivot— and the sheet outputs totals, averages, and any other metrics you find helpful.
• All results show in clear tables and, where useful, simple charts (bar or line is fine; nothing fancy).

Keep everything inside one workbook, no external add-ins. A short hand-off note explaining the key formulas and how to reset for a new month will close the project.