Start and end date columns advanced by one year

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!

Best Answer


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You could insert a temporary date column and use

    =DATE(YEAR([Start Date]@row) + 1, MONTH([Start Date]@row), DAY([Start Date]@row))

    Dragfill this for all rows.

    Copy, then "Paste Special" and select "Values" to paste the temporary column dates into the Start Date column. Repeat for [End Date] and then you can delete the temporary column.

  • Thanks Paul.

    I think I've done step 1 here by including the formula on a row but it says #unparseable, so presumably i'm not including this properly! Help? I'm an A1 beginner with formulas, obviously :)

  • Thank you so much, this was so helpful!!!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. 👍️