Forum Discussion

durtiaga's avatar
durtiaga
Frequent Visitor
5 years ago
Solved

Consecutive days worked with reset

Hi all,   I have being using for a while a formula in excel to calculate the days worked in a row, but the number of rows now is too big to handle with excel, so I'm trying to get the same result w...
Need Help
  • durtiaga's avatar
    durtiaga
    5 years ago

    Hi,

     

    Finally I have found a solution modificating slightly the steps from the thread indicated on the first post. The step with the index didn't work fine for me so I used the Index created on the first steps and got solved.

     

    Thanks for the comments.

    Best,

     

    Thanks

durtiaga's avatar
durtiaga
Frequent Visitor
5 years ago

Hi amitchandak 

 

Thanks for your comment.

 

My data has 1 column for dates with a row per day, so that solution would not fit in this case.