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



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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!