Calculate age between 2 dates

Question

Level 1

0 points

I need to calculate the age of children between their birthdate and a future date. What is the formula for this using Numbers?

Posted on May 23, 2015 1:01 PM

Reply

Answer 1

Level 7

20,395 points

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.

Reply