Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you calculate age from just having a Date of Birth? | Excel Discussion (Misc queries) | |||
How can I calculate age using a birth date in Excel? | Excel Discussion (Misc queries) | |||
calculate the age of someone from their date of birth | Excel Discussion (Misc queries) | |||
Calculate date of birth in Excel | Excel Worksheet Functions | |||
What is the formula to calculate Age when I have Date of Birth? | Excel Worksheet Functions |