How to manually calculate duration of task hierarchy
How can I manually calculate the duration of a parent task in a task hierarchy, i.e. the duration (in working days or calendar days) from the earliest start date of any child task of the hierarchy to the latest finish date of any child task?
Background: I have a Gantt chart in a sheet where I had to disable dependencies because I am linking most of the dates from other sheets. With dependencies disabled, durations don't get calculated automatically.
If there are any other suggestions to work around the limitation of not being able to use dependencies and links in the same sheet, I'm open to these as well.
Help Article Resources
Check out the Formula Handbook template!