+2Hello! 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!
Best answer by Kathryn_Walker
USe a formula like this DATEADD({Birthday}, 7, 'years')
Thank you so much! This worked perfectly!
+27USe a formula like this DATEADD({Birthday}, 7, 'years')
+27Thank you so much! This worked perfectly!
Glad it worked. Would you mind marking my first reply as the solution?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
