Hello,

I've got a formula which works perfectly to sum the number of days someone
has been off sick in a rolling year, however I also need to count the number
of occassions people have been off. Can anyone help me develop my existing
formula or is there a totally diferent way to do it? I'm stuck. :(

This is my current formula:
=SUMPRODUCT(($S$1:$IV$1=TODAY()-365)*S2:IV2)