Check for overlapping date ranges between sub tasks
I am looking for a formula that can check for overlapping date ranges between of the sub tasks on a project.
In the screenshot below the project has several sub tasks and I need a formula that will identify any overlap between the dates on the tasks.
I would like to prevent the use of references to cell numbers because I need to copy this formula across many lines.
Would you have any suggestions on how to resolve this?
I have tried to use COLLECT and COUNTIF but it seems I cannot compare 2 ranges of child records. I can only compare 1 column to a specific cell
Thank you very much !
Help Article Resources
Check out the Formula Handbook template!