Settings

Open in SheetsFree, with no account. What you type stays in this browser. Saves as Excel, OpenDocument or CSV.

Attendance register open in Sheets, in the light themeAttendance register open in Sheets, in the dark theme

What is in it

A row for each person and a column for each session marked P, A or L, with each person’s attendance and how many came to each session. The figures are examples to type over; the workbook runs wider than the columns shown here.

Attendance register
Mark each session P for present, A for absent or L for late. Late counts as there in the attendance figure. Change the dates in row 4 to your own.
Name2026-11-022026-11-092026-11-162026-11-232026-11-302026-12-072026-12-14
[Name]PPLPA
[Name]PAPPP

Worked out for you

These cells are formulas, so they follow whatever you type. Each is shown as written in its first row.

Present
=COUNTIF(B5:K5,"P")
Absent
=COUNTIF(B5:K5,"A")
Late
=COUNTIF(B5:K5,"L")
Attendance
=IF(L5+M5+N5=0,"",ROUND((L5+N5)/(L5+M5+N5)*100,0)&"%")
There at each session: 2026-11-02
=COUNTIF(B5:B34,"P")+COUNTIF(B5:B34,"L")
There at each session: 2026-11-09
=COUNTIF(C5:C34,"P")+COUNTIF(C5:C34,"L")
There at each session: 2026-11-16
=COUNTIF(D5:D34,"P")+COUNTIF(D5:D34,"L")
There at each session: 2026-11-23
=COUNTIF(E5:E34,"P")+COUNTIF(E5:E34,"L")
There at each session: 2026-11-30
=COUNTIF(F5:F34,"P")+COUNTIF(F5:F34,"L")
There at each session: 2026-12-07
=COUNTIF(G5:G34,"P")+COUNTIF(G5:G34,"L")
There at each session: 2026-12-14
=COUNTIF(H5:H34,"P")+COUNTIF(H5:H34,"L")
There at each session: 2026-12-21
=COUNTIF(I5:I34,"P")+COUNTIF(I5:I34,"L")

Filling it in

  • Change the dates in row 4 to your own sessions; there is room for ten.
  • Use the same three letters throughout. Anything else, such as a tick, is not counted.
  • Late counts as there in the attendance figure. If you want lateness to count against it, change the formula in the Attendance column.

More templates

All 32 templates