Confident Cells

The Bradford Factor in Excel

20 November 2026 · 2 min read

The Bradford Factor is the number of spells of absence, squared, times the total days absent: S × S × D. In Excel, =B2^2*C2 with spells in B2 and days in C2. It scores lots of short absences higher than one long one.

A worked example

Over a year, Ava had one absence of 10 days. Ben had 5 separate one-day absences. Both lost some time, but the factor treats them very differently:

=B2^2*C2
ABCD
1NameSpellsDaysBradford Factor
2Ava11010
3Ben55125
4Cara3654
D2 holds =B2^2*C2, copied down. The ^2 squares the number of spells.

Straight from an absence log

Usually you have a log with one row per spell of absence, not a summary. COUNTIF counts each person's spells and SUMIF adds up their days (see SUMIFS):

ABCDEFGHI
1NameFirst dayDaysNameSpellsDaysFactor
2Ben12/01/20261Ava11010
3Ava02/02/202610Ben55125
4Ben16/03/20261
5Ben04/05/20261
6Cara11/05/20262
7Ben22/06/20261
8Ben14/09/20261
The log on the left has one row per spell. Ben has 5 spells and 5 days, so 125.

To get the spells from first and last dates, count working days for each row first with NETWORKDAYS.

Using it fairly

Employers set their own trigger points, such as a conversation at 50 and a formal review at 200. The score is a prompt for a conversation, not a decision: absences linked to disability, pregnancy or a long-term condition need different treatment. Check your organisation's policy.

Common mistakes

Squaring the days instead of the spells

=B2*C2^2 squares the days, so Ava's single 10-day absence scores 100 instead of 10. It's the spells that are squared.

Counting a long absence as several spells

One absence that runs over a weekend is still one spell. Log each spell once, from first day off to last.

Unlocked ranges in the summary

Without $ signs, COUNTIF's range slides down as you copy, and later people lose spells. Lock the log ranges.

Try it now

Your turn

In D2, work out each person's Bradford Factor: their number of spells of absence, squared, times their total days absent. Your formula will be copied down to D7.

ABCD
1NameSpellsDaysBradford Factor
2Ava110
3Ben55
4Cara36
5Dev214
6Eve44
7Femi00