Attendance sheet templates for Excel

Monthly attendance registers for staff and for classes. Pick the month and the day numbers and weekday labels redraw; then mark each person each day from a dropdown. Present days turn green, absences red and leave amber, weekends grey out, and the columns at the end count present, absent and leave days and work out an attendance percentage that turns red below 75%.

Templates

Employee attendance sheet (Excel spreadsheet): A monthly employee attendance sheet in Excel: mark present, absent, leave, half day or holiday, with automatic totals and attendance %.
Class attendance register (Excel spreadsheet): A student attendance register for a month: mark present, absent, late or excused for each student and see their attendance percentage.
Salary sheet (Excel spreadsheet): A monthly salary sheet format in Excel: basic, HRA and allowances, paid days, PF, ESI, professional tax, TDS and net pay for each employee.
Weekly timesheet (Excel spreadsheet): A weekly timesheet template: start, finish and break times give daily hours, regular and overtime hours, and total pay.

How to use these templates

Choose the employee or class version and set the month at the top.
List names in the second column; the numbers and totals extend to every row in the table.
Each day, pick a code from the dropdown: P present, A absent, L leave or late, HD half day, H holiday, WO weekly off (employees) or E excused (students).
At month end, copy the totals into payroll or a report card, then change the month and clear the marks for the next one.

Keeping attendance records that hold up

Use the codes rather than ticks or words. The counts depend on exact codes, and a stray "present" typed by hand is not counted.
Mark holidays and weekly offs too, so blank cells mean "not yet marked" rather than "day off".
A half day counts as half present and half absent in the employee sheet, which suits most leave policies; change the formula if yours differs.
Paid days for payroll are usually present days plus paid leave, holidays and weekly offs. The salary sheet template takes paid days as an input.
Schools often require 75% attendance to sit exams, so the class register highlights anyone below that line.

Frequently asked questions

Does the sheet work for any month and year?

Yes. Change the month cell and the dates, weekday labels and weekend shading update, including 28, 29, 30 or 31 days.

How is attendance percentage calculated?

For employees: present days divided by present, absent and leave days. For students: present, late and excused days divided by days marked, so unmarked days do not count against them.

Can I track a whole year?

Keep one copy of the sheet per month in the same workbook (right-click the tab and choose Move or Copy), then add a summary sheet that totals each month.

Will it work in Google Sheets?

Yes. Import the .xlsx into Google Sheets; dropdowns, colours and totals carry over.