Hello
I know how to look for overlapping dates for the whole range however I am trying to find out if the dates overlap if the Account ID equal to eachother.
Any help would be great!
=SUMPRODUCT((J2<=enddate)*(K2>=startdate))>1
Capture.PNG
Hello
I know how to look for overlapping dates for the whole range however I am trying to find out if the dates overlap if the Account ID equal to eachother.
Any help would be great!
=SUMPRODUCT((J2<=enddate)*(K2>=startdate))>1
Capture.PNG
Welcome to the forum.
Maybe you can add another criteria like below...
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Let me see what I can get done! Thank you, im not the greatest at excel but I am trying to learn
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks