Hi,
I need help with an absence tracker! I would like to have a formula that show amount of periods the employee has been absence.
like i have the name of the employee (Mike) in colum A2 and after that to S2 all days in the month.
so say that Mike is sick for 3 days that i mark (S) in cell B2 - C2 - D2 thats is 3 days but one period.
But mike is also sick 2 more days that month that i mark (S) in cell H2 - I2 thats 2 days and 1 period.
so what i need help with is the period part, what kind of formula will help me with this?
Thanks in advance // Fredrik