T
taco
Hi Everyone;
I'm using an excel worksheet in order to follow employee attendance. Looks
like this;
Employee
Name 02/04 03/04 04/04 05/04 06/04 Worked
weekend days
Thu Fri Sat Sun Mon
A OFF OFF 23 21 21 2
B 15 OFF OFF 23 21 1
C 17 15 OFF OFF 23 0
D 19 17 17 OFF OFF 1
E 19 19 17 15 OFF 2
F 21 19 19 17 15 2
I cannot find the formula to have the worked weekend days on the last column
automaticly. I've tried SUMPRODUCT function with no success.
Any help will be appreciated. Thanks a lot in advance for your time and
advice.
Regards.
I'm using an excel worksheet in order to follow employee attendance. Looks
like this;
Employee
Name 02/04 03/04 04/04 05/04 06/04 Worked
weekend days
Thu Fri Sat Sun Mon
A OFF OFF 23 21 21 2
B 15 OFF OFF 23 21 1
C 17 15 OFF OFF 23 0
D 19 17 17 OFF OFF 1
E 19 19 17 15 OFF 2
F 21 19 19 17 15 2
I cannot find the formula to have the worked weekend days on the last column
automaticly. I've tried SUMPRODUCT function with no success.
Any help will be appreciated. Thanks a lot in advance for your time and
advice.
Regards.