Free Employee Attendance Tracker Template (Excel)

Tracking attendance on paper or in a messy spreadsheet makes month-end painful. This free template gives you one clean sheet per month: pick a code for each employee each day, and the totals and attendance percentage calculate automatically.

Download the free attendance tracker (.xlsx)

Employee Attendance Tracker template preview with sample data
Preview of the Employee Attendance Tracker template with sample data. Download it above and replace the examples with your own.

What is inside

Feature How it works
Automatic calendar Enter the first day of the month; day numbers and weekday names fill in by themselves
Your weekend Choose Fri-Sat or Sat-Sun; weekend days are shaded grey
Drop-down codes P, WFH, H, A, L and S, so everyone records attendance the same way
Colour coding Absences in red, leave and sick days in amber, work-from-home in blue
Automatic totals Present, absent, leave/sick and attendance % for each employee
Working days Number of working days in the month, based on your weekend
Up to 25 employees Add more by inserting rows above the last employee row

Attendance codes

Code Meaning Counts as
P Present 1 day present
WFH Work from home 1 day present
H Half day 0.5 day present
A Absent Absent
L Leave (annual or approved) Leave / sick
S Sick Leave / sick

How to use it

  1. Enter the month: type the first day of the month in cell B2 (for example 1/10/2026).
  2. Choose your weekend in B3.
  3. Add your team: employee names and departments in the yellow cells.
  4. Record each day: click a cell and pick a code from the drop-down. Leave weekends and public holidays empty.
  5. Check the totals on the right at the end of the month.
  6. Next month: right-click the sheet tab → Move or Copy → tick Create a copy, then change B2 and clear the codes.

How the formulas work

  • Days present: =COUNTIF(C6:AG6,"P")+COUNTIF(C6:AG6,"WFH")+0.5*COUNTIF(C6:AG6,"H")
  • Absent days: =COUNTIF(C6:AG6,"A")
  • Attendance %: days present divided by the number of days with a code, so empty weekend and holiday cells do not count against anyone.
  • Day numbers: each column adds 1 to the start date, and stays blank after the last day of the month.

Want to understand COUNTIF and friends? See 25 Excel formulas every office worker should know.

Example: one employee’s month

Say June has 22 working days with a Friday–Saturday weekend. Ahmed’s row in the tracker shows 18 × P, 1 × WFH, 1 × A, 1 × L and 1 × S. The totals then read:

Present (P + WFH) Absent Leave / sick Attendance %
19 1 2 86% (19 ÷ 22)

Attendance % divides days present by all days that have a code, so leave and sick days lower it while empty weekend cells do not. A half day (H) counts as 0.5. If your policy treats approved leave as attended, add L to the days-present formula.

Daily attendance routine (2 minutes)

  1. Open the tracker at the start of the day and fill today’s column with P for everyone who is in.
  2. Change the code for anyone working from home (WFH), on leave (L), sick (S) or absent (A).
  3. At month end, copy the sheet, change the first day of the month and clear the codes.

Approved leave comes from the leave tracker, and hours worked belong in the timesheet template.

Tips

  • Public holidays: leave them blank, or add your own code (for example PH) to the drop-down list under Data → Data Validation.
  • Yearly summary: keep one sheet per month in the same file, then build a summary sheet or a pivot table.
  • Shared use: upload the file to Google Drive or OneDrive so a supervisor can update it from a phone.
  • Privacy: attendance records are personal data. Share the file only with people who need it.

FAQ

Is it free for business use?
Yes, use it in your business as much as you like. Please do not resell the template.

Does it work in Google Sheets?
Yes. Upload it to Google Drive and open it with Google Sheets; the drop-downs, colours and formulas carry over.

Can it calculate overtime or salaries?
Not in this version. It tracks days only. You can add columns for hours if you need them.

Is there an absence tracker in this template?
Yes. Absences (A) are coloured red and counted for each employee, and leave and sick days are counted separately, so it works as an absence tracker too.

Does it work in Google Sheets?
Yes. Upload the file to Google Drive and open it with Google Sheets. The drop-downs, colours and totals keep working.

Can I use a Saturday–Sunday weekend?
Yes. Choose Sat-Sun in the weekend setting and the weekend shading and working-day count update automatically.

Related guides

Leave a Comment