I’d like to use numbers to determine the ages of the children in our daycare, so I can see at a glance if we are complying with the maximum allowed for each age bracket.
It would also be nice to know when a child will be growing into the next bracket, therefore creating an opening for a new baby.
You do great work. Thank you
—–
George Holliday
MacMost Q&A Forum • View All Forum Questions • Ask a Question
How Do I Use Numbers To Calculate Someone’s Age If I Know Their Birthdate?
Comments: 2 Responses to “How Do I Use Numbers To Calculate Someone’s Age If I Know Their Birthdate?”
Comments Closed.
Use the DATEDIF function for this, with TODAY as the first value and the birthdate as the second, then YEAR ("Y") as the third. For instance, if the birthdate is in cell B8, then the function in C8 would be:
=DATEDIF(B8,TODAY(),"Y")
This calculates the years between the birthdate and the current date.
Read up on DATEDIF in the function help in Numbers to learn more about it.
Gary, that was soooo helpful. Thank you very much.