Staff Absence Calculations

Hi,

I have found many helpful solution in this forum but I struggle with another thing and hope that somebody is able to find the way to resolve it.
I need formula that will count the sickness occasions for the whole year(all information in one excel tab) and for the last six months (same data).
Please find the fraction of my spreadsheet attached.
0 - day off
E - early shift
L - late shift
S - sick
HDS - half day sick

I have only filled in January and December with "S" and "HDS"

I would highly appreciate your help.

Hi Bernie,

Thank you for coming back to me so quick.
Probably I didn't make myself clear enough but I want to count occasions of sickness not days i.e E E S 0 0 S L is only one occasion split by two rest days. Staff is sick on Friday then has two rest days and then continues being sick on Monday.
As you can see Andy also has rest days on random days in the week.
Would you be able to help?

Hi Bernie,

I have followed your instructions but I constantly get an #Name? errorAttachment 690465

Hi Bernie,

I am coming back to you on the same topic long time after your last answer.
I would really appreciate if you could have a look on the attached spreadsheet to find out why do I get the #name? error. This time I have attached the excel file instead of picture.
Thank you so much for your help.

Simon

Hi Bernie,

Thank you so much for your help. I really appreciate it. Everything works perfectly.
If you don't mind I have another question on this.

How the VBA code would look like if the rest days would have been marked as "blank fields" instead of "0" on the spreadsheet?
I've tried to play with the above code but couldn't figure it out by myself.
Thank you.