View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] droidpikz@gmail.com is offline
external usenet poster
 
Posts: 1
Default Calculate birth date from age

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.