Change the year of the date when the type of the column is date

Options

Hi, 


I want to create automation that sends alerts on the day before birthday dates for someone specific.


 I create a birthday column that is defined as type date.


The problem is when the year is past, the year on the date does not update automatically and then I need to update the year. 


How can I create a formula that updated the year automatically?


For example:


The date now is 11/4/2021, next year will update automatically to 11/4/2022. 


I mention - In every row there is a different date. 


Thanks in advance, 


Ofek :)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!