MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Use Numbers To Calculate Someone’s Age If I Know Their Birthdate?

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

Comments: 2 Responses to “How Do I Use Numbers To Calculate Someone’s Age If I Know Their Birthdate?”

    5 months ago

    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.

    George Holliday
    5 months ago

    Gary, that was soooo helpful. Thank you very much.

Comments Closed.