G
Gary
In column "A", rows "7-46" are cells to record the day of the week worked by
multiple employees. Each week is new and different. The day "MON" might be
recorded in rows 7-10, "TUE" might be in rows 11-15, etc. I want a formula
to count the numbers of days worked in a week. Although "MON" might show
multiple times it would be counted only once. The formula would return a
number between 0 and 7.
Regards
Gary
multiple employees. Each week is new and different. The day "MON" might be
recorded in rows 7-10, "TUE" might be in rows 11-15, etc. I want a formula
to count the numbers of days worked in a week. Although "MON" might show
multiple times it would be counted only once. The formula would return a
number between 0 and 7.
Regards
Gary