Assistance calculating the date when a child turns 7

Topic Labels: Formulas
Jump to Solution
1122 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!


1 Solution

Accepted Solutions

Thank you so much! This worked perfectly!

See Solution in Thread

3 Replies 3

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?