Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I need to calculate the age of children between their birthdate and a future date. What is the formula for this using Numbers?
Hi Tiffany,
The DATEDIF function is your friend
Formula in C2
=DATEDIF(B2,TODAY(),"Y")&"y"&DATEDIF(B2,TODAY(),"YM")&"m"
For a future date, substitute that date for TODAY.
Regards,
Ian.
Calculate age between 2 dates
