Project Plan with successor and predecessor dates

[armour919]

Good day,

Building out a project plan trying to pull in predecessor dates to the successor. I wrote a formula to count the "." in the task #. I wanted to pull the max end date of the successors of the predecessors. So for 1.9's end date would like to receive the end date for 1.9.1. The issue I face is writing something that looks at them in sections and not pull in the dates of the next set of successors tied to another predecessor. Any help? preferred not to write any VBA

#	Task	Lead	Successor>1	Start	End	Days	% complete
1.8	Training for Information Steward for MDM team	Kris	1		-	0	0%
1.9	Compile findings to Identify what data meets that criteria	Sonia	1		-	0	0%
1.9.1	Create rules in " Information Steward"	Sonia	2		-	0	0%
1.10	Excute the Information Steward data profiling	Sonia	1		-	0	0%
1.11	Business reviews the output of the profiled data and identifies the cleansing tasks	Data Steward	1		-	0	0%
1.12	Develop an plan to terminate drivers:	Sonia	1		-	0	0%
1.12.1	Request to IT/Business cleanse the data	Sonia	2		-	0	0%
1.12.2	Testing on QA2	Sonia	2		-	0	0%
1.12.3	Move to production	Sonia	2		-	0	0%
1.13	Perform QA the Information Steward profiling, validate results	Sonia	1		-	0	0%
1.14	Continuation of data cleansing:	Sonia	1		-	0	0%
1.14.1	Business requests to terminate	Sonia	2		-	0	0%
1.14.2	Develops program to terminate in all places, not just FM (or build pgm earlier in step so the business can clean their own data)	Sonia	2		-	0	0%

<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Twollaston]

Hey there, I was having trouble understanding what exactly you are requesting. I'm not sure what predecessor date you are referring to. Can you explain it differrently and possibly show what you want it to show when it's working correctly

 

[armour919]

I do not have end dates added yet but it would be added to the sheets.

Looking at 1.12 Develop a plan to terminate drivers, I would like to have it look at all the successors below, 1.12.1 - 1.12.3 and pull the max end date to the end date of 1.12 but not the dates for 1.13 or 1.14 and their successors of 1.14.1 & 1.14.2. Hope that makes more sense.