| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Birth date from age
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Birth date from age
=date(year(today())-a1-1,1,1)
assuming the 43 is in a1 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "JP6262AMY" escreveu: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Birth date from age
Fantastic! Thanks so much!
"Marcelo" wrote: =date(year(today())-a1-1,1,1) assuming the 43 is in a1 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "JP6262AMY" escreveu: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a date of birth to an age? | Excel Worksheet Functions | |||
| how to work out an age from a date of birth | Excel Worksheet Functions | |||
| formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
| calculate the age of someone from their date of birth | Excel Discussion (Misc queries) | |||
| Converting Date of Birth to Age | Excel Worksheet Functions | |||
Linear Mode
