calculating ages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the best way to calculate the age of a person in number of years,
months, days, given their birth date?
Getting the difference between dates in number of days, and dividing by 365
may not be correct to the exact day given leap years. Is there another way?
 
If birth date is in A1 and TODAY() is in B1, then B1-A1 will return the
number of days.

Make sure that the cell in which B1-A1 is is formatted as numbers.

Dave
 
Back
Top