Log In
Register
Home
December 7, 2021
Offline
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!
See Answer
Moderators
January 31, 2022
Offline
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.
Answers Post
December 7, 2021
Offline
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.
Moderators
January 31, 2022
Offline
But with PQ you can connect to an unsorted table and do the sorting in PQ. Your choice.
December 7, 2021
Offline
Thanks. I am new to PQ. I will investigate. Thank you!
1 Guest(s)
