Is it possible to change the dates day by a other column?

Hey everyone.

I have a quite challenging task to do and i hope someone can help me.

I have a date column with following informations:
Element 1 set to : Friday, 22.07. Week 29
Element 2 set to : Monday, 25.07. Week 30
Element 3 set to : Monday, 18.07. Week29
+many more

is it possible to change all the mondays to tuesdays? The week should stay and not change!

Element 1 set to : Friday, 22.07. Week 29
Element 2 set to : Tuesday, 26.07. Week 30
Element 3 set to : Tuesday, 19.07. Week 29

I hope someone can help me.

Thanks!

@DastinTot

Are you looking for a onetime change? Or will this be recurring?

Hi @DastinTot !

I think that a dependency column would be extremely helpful in your use case.

Dependencies created relationships between items and then that column in conjunction with the automation “Adjust the date of an item to reflect the changes mad in the date of it’s dependency item” can make it perfect for you use case.

To help setup your dependencies check out this article.

What this will do is it will maintain the days between Element 2 and 3 and as you shift forward Element 2 by one day, Element 3 will follow that shift forward one day.

Hope this helps!