Intersect date range

Hello, i’m trying right now to find out if 2 users have common disponibilities. I thought i could count the intersection of 2 list of ranges in order to do that but it seems not working as intended.

I tried this formula :

Unfortunatly, this works only if both of the users in the comparaison or the same.

Here’s a pic of the database:

When I try to compare manually with the following formula, it works.

I tried to merge with the formula :
and here is the result (seems to duplicate)
What i am doing wrong ?
If you need more informations, let me know !
Thank you in advance

This topic was automatically closed after 70 days. New replies are no longer allowed.