Will someone please assist me with this?
I am trying to get a count of the number of rows that have overlapping dates/times listed in two columns.
Column D (START) contains the start date and time.
Column G (END) contains the end date and time.
And I am trying to get the count of overlaps into column H.
So, if the formula found other rows in the worksheet that had date/time that overlapped the date/time in row 2, column H on row two would list how many other rows were found that overlap.
Ideally, it would add 1 to include it's own row. Ultimately, I need to know how many rows have a date/time that overlaps at all.
Thank you!
Bookmarks