Hi,

There must be a more robust way of doing it, but you could try this ARRAY
formula (commit it by hitting Ctrl+Shift+Enter, not just Enter):

=OR(StartDate1+ROW(INDIRECT("1:"&EndDate1-StartDate1+1))=StartDate2+TRANSPOSE(ROW(INDIRECT(" 1:"&EndDate2-StartDate2+1))))

Regards,
KL


"MissSara" wrote in message
...
Hello, I need a function which allows me to enter the start and end dates
for two date-periods, then returns 'True' if there is any crossover
(intersection) between the two periods. In simple terms if there is any
day (or days) which appears in both periods.

Can I do this with worksheet functions? or do I need VBA? Very grateful
for any tips on how I code it.

Sara