3 Replies Latest reply: Mar 13, 2014 4:07 AM by ashok Velisetty RSS

    How to count consecutive working dates?

    ashok Velisetty

      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.