Forum Discussion
Counting unique number of days in a data set
I would be very grateful for any ideas or advice on the following conundrum: I have approx. 600 line items of activities for a construction gantt chart, with Start and Finish dates. . I am tryin...
George145 Perhaps you can use the formulae demonstrated in the attached file. It calculates overlap as the duration between end dates for subsequent activities, only if the start date of the latest activity lays before the end data of the first. Otherwise, it returns zero.
Sorry - I just reread the remainder of your note and you had already stated this constraint.