I come again to ask for help for the following problem:
- I have a set of tasks that have a start date for the task and an end date for the task;
- For this set of tasks I needed to know, by VBA, in an orderly way, which periods (date range) where there are more overlapping tasks;
- In a first stage, the ordering of the data will be made, for the largest number of overlaps and within those of the one with the greatest overlapping days, that is, for periods with the same number of overlaps, the first is what has more days.
I say that it is in a first phase since in fact the ordering will be done by calculating a new "WEIGHT" that will be equal to WEIGHT = A1 * D1 * A1 / 3, and the ordering will be from the highest to the lowest WEIGHT, as you can see in the data on the right in the “OUTPUT” tab.
In the file I attach, I have a set of data, tasks and dates, and the expected results, number of overlapping tasks, date range and number of days.
All help will be welcome
Jorge Cabral
PS: Also in https://www.ozgrid.com/forum/index.p...periods-dates/
Bookmarks