Hi,
I have a spreadsheet that covers the year daily from Jan01 - Dec31. It
includes employees names and their shift pattern.
What I would like Excel to do if possible is to count the number of
instances an employee is off .. i.e. if an employee works Mon-Fri as their
shift, has Monday and Tuesday off sick, is in work for Wednesday and Thursday
then has Friday off sick .. Saturday and Sunday weekend then Monday sick
again, I would mark each cell that corresponds to the sick days and it would
return a total of 3 instances. Sorry if that is a bit long winded, hope it
makes sense.
Thanks for your help
Kev