Issue adding a year to a date

Raphael Lng

Hello,

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

Raphael

Hollie Green

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))

Hollie Green

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))

Paul Newcome

I agree with @Hollie Green. It just looks like there is a misplaced closing parenthesis.

Raphael Lng

Hi,

Sorry for late reply I was quite away from Smartsheet for a couple of weeks, but you are right, I forgot a parenthesis, thank you for your support !

Raphael