Employee Attendance Tracker

How do you calculate an attendance rate?

Days present divided by days scheduled, times 100. Over a standard US year of about 260 working days, an employee who missed 8 days was present for 252, which is an attendance rate of 96.9 percent and an absence rate of 3.1 percent. The absence rate is the more useful of the two because it is small enough to compare: a move from 3 percent to 4 percent is a third more absence, which a 97-versus-96 percent attendance figure hides. Two other numbers matter. The Bradford Factor weights how scattered the absence was: occasions squared, times total days. Ten days off in one stretch scores 10, while the same ten days taken one at a time scores 1,000, because short frequent absences disrupt a team far more than one long one. And the cost is simply days absent times the fully loaded daily cost of the employee, meaning wage plus employer taxes and benefits rather than base salary alone. One caution that overrides all of it: protected leave such as FMLA, an ADA accommodation or state paid leave must not be counted against an employee, so keep it out of these figures entirely.

The four numbers, and what each one is for

Each metric answers a different question, which is why reporting only one of them tends to mislead.

Why the Bradford Factor squares the occasions

The metric exists because total days absent treats two very different situations as identical. One employee is out for ten consecutive days after surgery; another takes ten single days scattered across the year. Both lost ten days, but only the second leaves a team unable to plan.

Squaring the number of occasions makes that difference visible. The surgery case scores 1 times 1 times 10, which is 10. The scattered case scores 10 times 10 times 10, which is 1,000. The same total, a hundredfold difference in score.

Trigger points are policy, not law

Scores are usually read against a scale of trigger points, and the version below is the one most commonly published in absence policies. It is a convention, not a standard: every employer sets its own thresholds, and some do not use the metric at all.

Treat a score as a prompt to have a conversation rather than a verdict. A high score with an obvious cause, a chronic condition, a child in daycare, a known flare-up pattern, is a reason to look at adjustments, not a disciplinary finding. Using the score mechanically is how employers end up penalising protected absence.

What must stay out of the numbers

Absence protected by law cannot be held against an employee, so counting it in an attendance metric creates liability even when nobody intended it. That covers FMLA leave, absence that is an ADA reasonable accommodation, state and local paid sick leave, jury duty, military leave and in many places time off for voting or for domestic violence matters.

The practical consequence for a tracker is that protected absence needs its own code, kept separate from the unplanned-absence count. The downloadable sheet has separate codes for that reason: an absence marked as sick or vacation is not counted the same way as an unexplained one.

What this page does not do

This is a calculator and a spreadsheet, not an attendance system. Nothing you enter is saved, sent anywhere or shared, there is no account, and reloading the page clears it.

A sheet is genuinely fine for a handful of people and a single month. It stops being fine when you need a running history, when several managers maintain their own copies, or when someone has to answer what the record said before it was edited. At that point the question is no longer arithmetic.