Calculate birth date from age

[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.

 

[Gary''s Student]

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.

 

[Tyro]

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

 

[Bill Sharpe]

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.

Your current approach works well for horses, but not people <vbg>

 

[David Biddulph]

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.]