Count consecutive dates as one occurrence

**PietBom** · 01-19-2017, 05:31 PM

I got a little further, but not yet at the end...........
Please check if this is going in the right direction.

**Bchez** · 01-19-2017, 09:22 PM

Thanks PietBom - I think your approach is interesting. I tried to keep it on the Summary tab as well with no luck. I also tried to do it without any helper columns. I appreciate you working on this. Thank you very much!

**Bchez** · 01-19-2017, 09:28 PM

Thank you PietBom. I tried to also stay on the Summary tab but I didn't use helper columns at first. Thank you for helping me, I really appreciate you.

**PietBom** · 01-22-2017, 07:38 AM

Originally Posted by Bchez

Thank you PietBom. I tried to also stay on the Summary tab but I didn't use helper columns at first. Thank you for helping me, I really appreciate you.

I worked on the formulas and came 1 step further.
In column N you find the formula to calculate the row number where the sum reaches 40 or more.
This formula works fine if it counts all hours regardless the criteria Illness.
But the rest seems to work.
Still more challenges

Count consecutive dates as one occurrence

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Count consecutive dates as one occurrence

Re: Count consecutive dates as one occurrence

Re: Count consecutive dates as one occurrence

Re: Count consecutive dates as one occurrence

Thread Information

Users Browsing this Thread

Similar Threads

How to count consecutive dates for each employee from a listing of absence dates?

Count number of occurrence between dates

[SOLVED] Count Consecutive Dates

Count No. of occurrence of consecutive values

Count Occurrence of date (6th April) between two dates...

Count # Sick Day Occurrences based on dates and the Duration of each occurrence in hours

[SOLVED] Unable to count the occurrence of years in a list that contains dates and text

Bookmarks

Bookmarks

Posting Permissions