Autofill Monday based on a deployment date
Hi - I have a "date of deployment column" that I would like to auto-populate the column to the left to be the Monday prior to that exact deployment date which I will be calling "Launch week date".
Also the the 3 columns to the left of that will need to populate 4 Mondays prior to launch week date, 6 Mondays prior to launch week date and 8 Mondays prior to launch week date.
Does this make sense? it is a sprint schedule system and I need them to autofill all those Mondays once you select ANY date in the "date of deployment column" screenshot below. I have tried so many formulas and it fails. help