A clean monthly attendance grid for your whole team. Mark each day with a status code — Present, Absent, Late, Vacation, Sick — and totals calculate automatically. Download for Excel or Google Sheets, no email required.
Free download. No email required.
| Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | … | Present | Absent | Days Worked |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aisha Khan | P | P | L | P | P | W | W | P | … | 20 | 0 | 21 |
| Ben Cooper | P | V | V | P | P | W | W | P | … | 18 | 0 | 18 |
| Carla Mendez | P | P | P | S | P | W | W | L | … | 19 | 0 | 20 |
| David Osei | H | P | P | P | A | W | W | P | … | 19 | 1 | 19 |
Preview of the template — the download includes formulas and all tabs.
Open the Monthly Attendance tab, set the month and year, and list one employee per row. Duplicate the tab each month to keep a full-year record.
Use the built-in codes — P (present), A (absent), L (late), H (half day), V (vacation), S (sick), HO (holiday). Edit the Codes tab if your company uses different ones.
Present, absent, late, and days-worked columns total automatically with COUNTIF formulas — no manual tallying at the end of the month.
At minimum: employee names, one column per day of the month, a clear set of status codes (present, absent, late, vacation, sick, holiday), and monthly totals per employee. This template includes all of that plus automatic COUNTIF totals and an editable code legend.
You don't have to build one — download this template free. It has a 31-day monthly grid, 20 employee rows (add more by copying a row), automatic totals, and a printable layout. In Google Sheets, use File > Make a copy to get an editable version.
Yes. The monthly grid fits landscape printing — set the print area to the grid, choose landscape orientation, and fit to one page wide. Many teams print it monthly and post it near the entrance.
In the US, the FLSA requires employers to keep records of hours worked for at least two years (payroll records for three). Keeping a tab per month in one workbook makes this easy — never delete old months.
Yes — attendance spreadsheets break down as teams grow because someone has to fill them in. ClockIt records attendance automatically from clock-ins on mobile, web kiosk, or a biometric device, and generates the same monthly report with zero manual entry. The free plan supports small teams.