Calculating a Bradford score from a list of dates.

Hi,
Thanks for your help. That works although I could do with an explanation for what some things mean.
The 1 in O2 is that the employee number? The '0001011 if P2 does that represent Thursday some how?

I'm sorry but I've been thinking about this and it's not going to work in the way I've given you!

I'm actually going to need a list of the dates each employee is scheduled to work and then an indicator to say whether they worked or were absent.

So it'll be a csv file as per the attached. I just have to see if I can get a file in this format now I'm confident I can.

You can assume that the csv file will be sorted by employee number then date order.

Thanks again for all your help.

Regards,
Jim.