Hello -
To start, I do not have O365. I have Excel 2016.
I have a table of sprint dates and need to know whether any of the dates overlap. If so, I'd like to be able to identify where the overlaps occur.
Thanks!
Two possible solutions (not in PQ though), provided that you sort the table by Start date, ascending.
=AND(B3<>"",OR([@Start]<=N(C1),[@End]>=B3))
or
=AND(OFFSET([@Start],1,0)<>"",OR([@Start]<=N(OFFSET([@Start],-1,1)),[@End]>=OFFSET([@End],1,-1)))
Both demonstrated in the attached file, as well as a PQ solution.
Thanks, Riny. Those are good solutions. However, in this scenario, I cannot make the assumption nor require that the table be sorted in any particular way. Nonetheless, I appreciate your kind assistance.
But with PQ you can connect to an unsorted table and do the sorting in PQ. Your choice.
Thanks. I am new to PQ. I will investigate. Thank you!
OK, perhaps I misunderstood your intentions, since you posted your question in the PQ section of the forum.
It was suggested I do so by a moderator. Thanks.