Auto populate dates based on new dates in a work back schedule

Iqra

I have set up a work back schedule with predecessors. I have new dates for some of the tasks, I don't want to manually change each date. What would be the best way to auto-populate new dates in a new column without changing the old dates? Is there any formula/ alternative option for this case? Thank you in advance.

kowal

hi @Iqra ,

What about typical Index / Match formula (or vlookup).

Here is how it works:

hope it helps.

https://www.youtube.com/watch?v=ZEyP07ooRR0