On Tuesday, March 11, 2008 at 12:05:21 AM UTC+5:30, Tyro wrote:
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" wrote in message
...
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.
hey use any android apps which is free.
https://play.google.com/store/apps/d....agecalculator
use this app which is free. You can calculate age with more information.