Finding the free project dates
I am running a number of tasks in a sheet, with each task having its own Start and Finish date.
What I need to find out, is a "free" period when there is absolutely no task running.
Task A is from Jan 1 to 10;
Task B is from Jan 5 to 12;
Task C is from Jan 16 to 20;
Task D is from Jan 15 to 25;
and so on....
In the above example, the free period is from Jan 13 to 14 as none of the task-dates falls within this time window!
Is there any way to find out all such "free" dates --either individually or collectively?
Help Article Resources
Check out the Formula Handbook template!