Forum Discussion
Newbie Question in Excel Formula's
I am creating a Excel sheet to calculate my company holidays over the annual period, and want it to calculate how many staff are off in any one day. So I want it to calculate FD, HD, UL so I know...
Assuming that the Monday codes are in F2:F10, enter the following formula in F11:
=SUM(SWITCH(F2:F10, "FD", 0, "HD", 0.5, "UL", 0, 1))
or
=COUNTA($A2:$A10)-COUNTIF(F2:F10, "FD")-COUNTIF(F2:F10, "HD")/2-COUNTIF(F2:F10, "UL")
Fill to the right to L11.