Fantastic. Thank you very much.
Sara
"KL" wrote in message
...
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
|