calculate date of birth with an end date and age

T

Tifosa

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating age from date of birth and ignoring if blank 5
"how do I calculate age by using date of birth details" 5
Calculating present age if date of birth is given. 3
create calculated field for age in pivot tables 4
formula to calculate age using birth date and current date 2
Conditional Formatting 1
Count/Calculation According to Age of the Person 1
How do i set up a sheet to count the years to retirement? 1

Top