Assistance calculating the date when a child turns 7

Hello! I am hoping someone can help me create a formula that will calculate the date on which a child turns 7 years old. I have listed their birthday and have figured out how to calculate the child’s age today, but am unsure of how to figure this other data point I need. What follows is a screenshot of the columns.

Thank you so very much for your help!


USe a formula like this DATEADD({Birthday}, 7, 'years')

Thank you so much! This worked perfectly!

Glad it worked. Would you mind marking my first reply as the solution?

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.