How to count consecutive working dates?

[#1]

Hi ,

I want to count number of consecutive  dates having data,if one user working more than 6 consecutive days then consider that agent is count one. otherwise if any agent worked 5 days after leave then no need to count that agent.

for more clarification see Example below:

Agent                               Dates
                 1            2             3          4          5          6          7          8          9          10

A              9:00        8:57        7:00     8:34      7:59     8:23     8:59        -          8:47      9:02

B               -             7:12       8:23     10:06     6:56     7:34     8:14        -           -          8:34

C               7:00        8:45       -           8:57       8:12     7:12     7:45       6:43     7:51     7:34

here i need answer is count of agnets working more than 6 days:2(A and C).

Can u suggest how to write expression for this???????????

I need agents count for monthly basis.

Thanks,

Ashok.    

[tresesco · Accepted solution]

May be like attached sample.

update: a bit correction was needed. please refer second attachment.

[er_mohit]

@See the attached file

[#4]

Hi Tresesco,

Thank u somuch yar, it working perfectly.

Thanks,

Ashok.

[Anonymous]

Hi,
I have a similar problem and would like to use the attached model but unfortunately I can not open the file.
Could the file be locked?
I have a valid license