If 2024 change to 2025 formula

Cassidy Tackett

Hello! I need help with updating formulas in a duplicated Smartsheet where the year is currently set to 2024, and I want to change it to 2025. Instead of manually going in and editing each formula, is there a quicker and more efficient way to do this? Additionally, I want to add an "IF" condition to ensure that if a cell is blank, the formula returns blank as well. Any suggestions on how to do this more effectively?

VBAGuru

You could try:

=if(Year([Date Column]@row)=2024,[Date Column]@row+365,[Date Column]@row)

Cassidy Tackett

Thats not working..

VBAGuru

Are both your original Date column and the new date column formatted as a Date column?