Hello,
I'm trying to create a register, where it will calculate the Bradford Score (episodesOfSick^2*numberOfDays).
This would be easy to do if all the cells of working days were next to each other. However, as shown on the attached file i need rows separating weeks and months. So if someone's sickness is carried from one week to the next the spreadsheet counts it as two episodes of sick and not one.
Is there a solution?
Thanks in advance
Matt
Bookmarks