date overlap

I've been thinking about this for a few weeks now and can't come up with a workable solution. I've searched for weeks trying to find an answer but I'm officially stumped. Any help would be huge! Situation: I have a list of names with a start and an end date for performance reports as shown...

Hi I have a query in Power Query like: Site id | Start Date | End Date | Value 1 | Value 2 | Value 3 | The date periods are random and dataset comes every month as a txt file. Newer txt often contain corrections of older ones but do not necessarily share start date or end date. My goal is to...

<tbody> A B C D 1 Name Start End Conflict? 2 Apples 12/1/14 12/2/14 YES 3 Oranges 12/1/14 12/2/14 NO 4 Apples 11/30/14 12/2/14 YES 5 Apples 12/4/14 12/5/14 NO 6 Apples 11/30/14 12/1/14 YES </tbody> Hoping for some help. I'm open to any solution. I want to compare the "Name"...

Hi there, please can you assist with my question - I have 5 sets of start and end dates each for 5 therapies. I need to determine if any of these 5 date periods overlap. I have inserted an example below, (in this case the person is only on 2 therapies, but I dont think it matters to my overall...