Excel: Counting Holiday & Sunday as leaves

Hi all excel experts, Here I have a problem with counting number of leaves. Suppose below is my data If you see I am counting total leaves for each employee. But here is one condition if between two leaves any sunday or any holiday will come that should also be counted as leaves.Like Name 2 there is one Holiday (H) and one Sunday(S) followed by and precedded by L. So they should also get counted as Leaves. There can be situations like PPLLLHHHLLLPP or PPPPLLSLPPH.

Emp Name 1 2 3 4 5 6 7 8 TOTAL LEAVE
Name 1 P P L L H S P L 3
Name 2 P L L L H S L P 6
Name 3 P P P P H S P P 0
Any help regarding what formula should deliver me the result. I think frequecy can do it but I am unable to figure out how? Thanks in advance. Regards! SM.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of December 19, 2013.

For more resources for Microsoft Excel