Start and end date columns advanced by one year
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!
Help Article Resources
Check out the Formula Handbook template!