Hello all,
Hope I could find help about my question.
I have a worksheet with 8 rows each row contains a name of employee
and its timesheet during the next two years.
I separated the cells based on weekly days-off or days-on of the
employee and colored therefore.
The whole employees are working rotation 4/2 (4 weeks On, 2 weeks
Off).
My request is to create a sheet in the same workbook that I can see
through it the summary of two groups as follows:

1- Group 1 : category of employees on days-Off .
2- Group 2 : category of employees on days-On .

I want this will affectionate according to the today date.

It means one employee has two probabilities: On / Off

Sorry if I could not has the good English to explain what I am looking
for but the link below has the file I want to update; for further of
your references:

http://www.sendspace.com/file/g2f74m

Hope I will hear some suggestions.

Regards
Lassaad