Thank you! And thanks for the tip on calculating the working days!
Do you know what formula can be used so that any absences older than 12 months are excluded?
I've updated the spreadsheet with an example of what I'm trying to explain, hopefully it makes sense!
Edit: the additional row has the wrong date in - should be 2020 so that there is more than 12 months between the new absence and older periods of absence
Thanks!
Bookmarks