I need to calculate how many days an individual is out on sick leave (including weekend, scheduled days off and holidays).
I need to do this throughout the year and there are many rows of information.
A2 = 1/30/06(1st day out)
B2 = 3/15/06(last day out)
C1 = January // C2 = 2(result)
D1 = February // D2 = 28(result)
E1 = March // E2 = 15(result)
I need a formula to caluculate C2, D2 & E2
Any help???
Thanks
I need to do this throughout the year and there are many rows of information.
A2 = 1/30/06(1st day out)
B2 = 3/15/06(last day out)
C1 = January // C2 = 2(result)
D1 = February // D2 = 28(result)
E1 = March // E2 = 15(result)
I need a formula to caluculate C2, D2 & E2
Any help???
Thanks