Add years to a date

Jennifer Locke

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

Thanks!

SoS | Dan Palenchar

Use:

=DATE(YEAR([Date of Birth]@row) + 26, MONTH([Date of Birth]@row), DAY([Date of Birth]@row))

SoS | Dan Palenchar

Use:

=DATE(YEAR([Date of Birth]@row) + 26, MONTH([Date of Birth]@row), DAY([Date of Birth]@row))

Jennifer Locke

Thank you, Dan!!! Knew I was missing something basic. :)

Alyssa Chun

Hello I am trying to do the same thing but the formula just is not working for me. I've copied it exactly and still getting the error message. Can you give me any suggestions?

UPDATE: I found the error and now it works!! thanks

Clee9

This formula only works if you change the column settings to be "Date" instead of "Text/Number"! Thiis was key. Otherwise, I kept getting an error!