Add years to a date

Hi, I'm trying to populate a column with a future date. What formula can I use to take a birthdate entry in one column and add 26 years? Seems like a simple enough ask, but nothing I've seen in other questions seems like a plug & play answer to me.

Both columns are date field settings



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!