Simple formula to increase the date by 12 months, or 1 year less one day

Hello,

I have played with this until my brain is numb.

=DATE(YEAR(Entry@row) + 1, MONTH(Entry@row), DAY(Entry@row) -1)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!