Issue adding a year to a date
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
Best 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))
Answers
-
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))
-
I agree with @Hollie Green. It just looks like there is a misplaced closing parenthesis.
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!