Hi,

Thanks for replying. We should ignore whether it is weekend or pub holidays. Just derive consecutive from the entry date. For example: staff a enters on a fri sat sun and following tues. so on the entry record of fri will be 1 consec day, sat 2 and sun it will show 3 consecutive day but on 1 for tues. Will reset the counter only there is a gap(no back to back entry date)