Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate date of birth with an end date and age
I have a sheet with a retirement date which will be the x birthday, and the
age (x) of the client at that date. I need to get a date of birth for each of these people. Anyone know a formula that will achieve this?? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate date of birth with an end date and age
Worker Retires Age DOB
Fred 15-Mar-10 65 15-Mar-45 "Fred" is in A2, retirement date in B2, age in C2, DOB in D2 In D2: =DATE(YEAR(B2)-C2,MONTH(B2),DAY(B2)) This assume the retirement date exactly corresponds (month & day) to Fred's DOB I have used a dd-mmm-yy date format to save confusion (international vs USA) but the dates could be in dd/mm/yyyy or mm/dd/yy, etc. best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Tifosa" wrote in message ... I have a sheet with a retirement date which will be the x birthday, and the age (x) of the client at that date. I need to get a date of birth for each of these people. Anyone know a formula that will achieve this?? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate birth date from age | Excel Discussion (Misc queries) | |||
How do you calculate age from just having a Date of Birth? | Excel Discussion (Misc queries) | |||
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) |