I would like to calculate an age for a person in Numbers by subtracting their date of birth from the current date or another date that I input. How can I use a formula to do this?
IMAC (RETINA 5K, 27-INCH, LATE 2015), macOS Sierra (10.12.5)
Use the DATEDIF function. If birthday is in $A2, then this returns the age of the person:
=DATEDIF($A2,TODAY(),"Y")
The "Y" tells the function to return years.
Use the DATEDIF function. If birthday is in $A2, then this returns the age of the person:
=DATEDIF($A2,TODAY(),"Y")
The "Y" tells the function to return years.
MacMostGary,
Perfect! Thank you.
Joshua
How can I calculate an age in Numbers?
