Comparison between 1 value and 2 columns

Bonjour,

I got a sheet with start and end dates. I want to create a formula, which, fo a given date, checks this date isnt in any [start;end] interval. I'd rather avoid using VBA.

example for April 20th : (date are in dd/mm format)
sheet1 :

Please Login or Register  to view this content.

sheet2 :

Please Login or Register  to view this content.

in sheet1, April 20th isnt in any interval, I want my formula to return TRUE
avec le tableau 2, elle est dans le premier intervalle, je veux FAUX

I already succeeded in checking for 1 row :
=AND(mydate>A2;mydate<B2)
But I don't know how to extend that to a full row without using VBA...