Auto Update a Column of Dates based on another cell/columns value

[kB4156]

Hello,

First off I want to say thank you to all the moderators/ administrators/ any one else that actively contributes with helping to answer these types of questions.

I am pretty new to conditional formatting and some of the more advanced formulas used in Excel. Having said that i will get straight to my question.

This question only involves two columns ... a deployment date column and a "wave" column (W1, W2, W3, W4, etc.).

Here is an example table to better demonstrate:

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Wave
[/TD]
[TD]Deployment Date
[/TD]
[/TR]
[TR]
[TD]W1
[/TD]
[TD]12/15/2013
[/TD]
[/TR]
[TR]
[TD]W1
[/TD]
[TD]12/15/2013
[/TD]
[/TR]
[TR]
[TD]W2
[/TD]
[TD]12/19/2013
[/TD]
[/TR]
[TR]
[TD]W2
[/TD]
[TD]12/19/2013
[/TD]
[/TR]
[TR]
[TD]W2
[/TD]
[TD]12/19/2013
[/TD]
[/TR]
[TR]
[TD]W3
[/TD]
[TD]12/27/2013
[/TD]
[/TR]
[TR]
[TD]W3
[/TD]
[TD]12/27/2013
[/TD]
[/TR]
[TR]
[TD]W3
[/TD]
[TD]12/27/2013
[/TD]
[/TR]
[TR]
[TD]W3
[/TD]
[TD]12/27/2013
[/TD]
[/TR]
</tbody>[/TABLE]


So essentially what I am trying to do here is to have date correlate to the wave, in that, if the date is changed in one of the date fields that correspond to W2 or Wave 2 ... I want all of the corresponding dates for W2 to change instantly. So based on table above ... change 12/19/2013 to 12/21/2013 in one row ... all the rest of the dates that correspond to W2 (Wave 2) change in instantly. I will need to do this for all the waves/ dates but if I can get the logic for one than I can substitute that logic for the rest.

If anyone could help or needs more info in order to help please let me know.

Again, thank you.

 

[kB4156]

Please disregard this post as I have since found a solution. Thank you!