Hi Ivo,
Your formula can be further reduced to:
=AND(Start2<=End1,Start1<=End2)
BTW the logical values TRUE and FALSE are usually used without quotation
marks, otherwise the values returned are text strings.
Regards,
KL
"Ivo" wrote in message
...
Problem with the quotation marks so here it is with 1's and 0's instead of
true/false
=AND(OR(IF(Start2<End1;1;0);IF(Start2=End1;1;0));O R(IF(Start1<End2;1;0);IF(Start1=End2;0;0)))
|