Hey, I hope I've placed this correctly.

In short, I am able to extract employee roster data from a database into Excel (2003). A simple example of a 2-week roster would be 'Duty/OFF/SICK/SICK/SICK/OFF/SICK/SICK/Duty/OFF/Duty/Duty/Duty/Duty'


I would like to find a way for Excel to count the two periods of sickness which are currently separated by an OFF day as one period of sickness.


Could someone possibly offer some direction as to which functions/formulas could be used to scan a whole year and count occurrences of sickness which may be separated by OFF days, please? Thanks very much for any thoughts.


Thomas