Hi,
I'm getting a list of dates of absence output from a time & attendance system. They can't, or won't, calculate a Bradford score for me. Can anyone help me do it in Excel.

A Bradford score is relatively simple it's just : Sē x D = B where S is spells of absence, D is total days of absence and B is the Bradford score.

e.g.
Absence
1st Jan 2018
2nd Jan 2018
3rd Jan 2018
1st Feb 2018
10th Feb 2018

2 spells of absence, 5 days of absence would give a Bradford score of 20.

whereas

Absence from 1st Jan 2018 to 19th Jan 2018 inclusive

1 spell of absence, 19 day of absence would give a Bradford score of 19.

There is an added complication of weekends not being counted. An absence from Thursday to Tuesday is only 1 spell and only 4 days. The final complication, although I could probably live without this, is that the weekend might be Sat & Sun for one employee but Sun & Mon for another.

As I said above I can get a raw list of dates per employee and I like to use Excel to calculate Bradford scores for each employee.

Regards,
Jim.