Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Assistance calculating the date when a child turns 7

Topic Labels: Formulas
Jump to Solution
381 3
Showing results for 
Search instead for 
Did you mean: 

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?