Start and end date columns advanced by one year

Rachel Jacob
Rachel Jacob ✭✭
edited 07/22/20 in Formulas and Functions

Hi all,

I'm trying to flip ALL dates in the start column ahead by 1 year and ALL dates in the finish column ahead by one year. We're utilizing Smartsheet as our critical path platform so this is something we need to do year over year and manually updating ~1000 rows is not realistic.

An exact date is not the most important thing, within a day or two of these dates flipped ahead one year is totally fine!

I've perused through other discussion questions and threads and can't find a solution so far, thanks in advance for your support!

Workplan 2021.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!