Calculate birth date from age

  • Thread starter Thread starter JP6262AMY
  • Start date Start date
J

JP6262AMY

I periodically have a situation where I know the ages of a list of people and
need to convert the ages into birthdates.

i.e. Age 43 - instead of manually calculating that this persons birthday is
approximately 1/1/1964, how do I enter a formula to change the age into a
birthdate?

Any assistance anyone can provide will be greatly appreciated.
 
There are about 365 correct answers. If a person's age in in A1 and today is
her birthday, then:

=DATE(YEAR(TODAY())-A1,MONTH(TODAY()),DAY(TODAY()))

will give the date on which she was born.
 
Dates are simply numbers. Excel's date range is Jan 1, 1900, day 1 through.
Dec 31, 9999, day 2,958,465. If the age is in A1 then you could use
=(TODAY()-A1*365.25) to get an approximation and format the answer as a
date. But be aware that you could be off by almost a whole year.

Tyro
 
JP6262AMY said:
I periodically have a situation where I know the ages of a list of people and
need to convert the ages into birthdates.

i.e. Age 43 - instead of manually calculating that this persons birthday is
approximately 1/1/1964, how do I enter a formula to change the age into a
birthdate?

Any assistance anyone can provide will be greatly appreciated.
Click to expand...
Your current approach works well for horses, but not people <vbg>
 
Isn't the OP's suggestion a year wrong for horses? :-)
Isn't a horse born in 2004 considered a 4-year old from 1/1/2008? [The
experts at Cheltenham today could tell us.]
 
Back
Top