paulma1960
New Member
- Joined
- Aug 23, 2021
- Messages
- 8
- Office Version
- 365
- 2019
- Platform
- Windows
I'm doing project analysis on milestones (MS's) and their completion dates.
Around 120 of the MS's have one or more dependent milestones (DMS's) and issues have arisen because some DMS's have completion dates that exceed the MS date.
Most MS's with DMS's have one or two DMS's, but I have identified some MS's with up to 26 DMS's.
And each DMS can have its own DMS's (0-n). This is my main challenge, to work out for a MS, what is the maximum completion date for any DMS, and any DMS dependent on a DMS. Calculations with regular formulas are going to be too bulky, too many columns and I'm looking for a solution, probably using array formulas. Any suggestions appreciated.
A sample mockup of what I've done so far with regular formulas is below. I've got the max dates of the DMS's, but not the DMS's of the DMS's.
Around 120 of the MS's have one or more dependent milestones (DMS's) and issues have arisen because some DMS's have completion dates that exceed the MS date.
Most MS's with DMS's have one or two DMS's, but I have identified some MS's with up to 26 DMS's.
And each DMS can have its own DMS's (0-n). This is my main challenge, to work out for a MS, what is the maximum completion date for any DMS, and any DMS dependent on a DMS. Calculations with regular formulas are going to be too bulky, too many columns and I'm looking for a solution, probably using array formulas. Any suggestions appreciated.
A sample mockup of what I've done so far with regular formulas is below. I've got the max dates of the DMS's, but not the DMS's of the DMS's.
