Sub item date automation

I have pretty unique use case it seems as I have searched and really can’t find a solution.

Essentially what I want to do is have a sub item date be automated based on the date in the main column. The main date is not a TODAY date and may be several months ahead in time for each item, so using a date/push doesn’t work as the date is different for each item.

Has anyone encounter this? If so what was your solution. Open to any and all ideas! :slight_smile:

Example: