Free Bradford Factor Calculator (UK)
The Bradford Factor is a simple score that shows how much short, frequent absence disrupts a team. Add each separate absence below (how many working days it lasted) and the calculator does the rest. Nothing you type leaves your browser.
Calculator
Add one line per separate absence in the period you use (most employers use the last 52 weeks).
How the Bradford Factor works
The score is S × S × D:
- S is the number of separate absences (spells) in the period.
- D is the total number of days absent in the period.
Because the number of spells is squared, lots of short absences score much higher than one long one. That is the point: frequent unplanned absence is usually harder for a team to cover than a single planned-for illness.
Worked examples
- One absence of 10 days: 1 × 1 × 10 = 10
- Five absences of 2 days each (10 days in total): 5 × 5 × 10 = 250
- Ten absences of 1 day each (10 days in total): 10 × 10 × 10 = 1,000
All three people were off for 10 days, but the scores are very different.
Using it fairly
- Trigger points are set by each employer, not by law. Many use stages such as a conversation, then a review meeting, then a formal stage, but write yours into your absence policy and apply them the same way to everyone.
- Treat the score as a prompt for a conversation, not an automatic decision. Talk to the person first.
- Leave out or adjust for disability-related absence, pregnancy-related absence and other protected situations. Treating these the same as other absence can be discrimination under the Equality Act 2010.
- Be clear about the period (for example a rolling 52 weeks) and what counts as a day (working days, not calendar days).
- Keep records private and only share them with people who need them.
This is a guide and calculator, not legal or HR advice. For a specific case, check ACAS guidance on managing absence.
Tracking a whole team?
The Staff Sickness Absence Tracker is a spreadsheet for Google Sheets and Excel. Log each absence once and it works out every person's Bradford Factor over a rolling period, totals days lost and highlights anyone who reaches your trigger points. No macros.
Get the tracker (£5.39, instant download)
More free UK calculators: holiday entitlement calculator and mortgage overpayment calculator.