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|
This question generated 22 answers. To proceed to the answers, click here.
This thread is current as of December 19, 2013.