Issue adding a year to a date


I am building a formula to add a year to an existing date in my sheet. So it looks it's working but I realise it doesn't take into account the day of my initial date, don't understand why.. Please see bellow the example:

=DATE(YEAR([Work at heights - Training date]@row) + 1; MONTH([Work at heights - Training date]@row; DAY([Work at heights - Training date]@row)))

Could someone help me please ?

Thank you very much


Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭
    Answer ✓

    The below formula worked for me. I believe you are missing a parenthesis after @row for the month and have an extra one at the end of the formula. I think you will have to change my comma's to semi colons based on other posts I've read my smartsheets is set up to use commas

    =DATE(YEAR([Work at heights - Training date]@row) + 1, MONTH([Work at heights - Training date]@row), DAY([Work at heights - Training date]@row))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!