Sean Timmons wrote:
Here is your answer.

Assume DOB is in B1 and Date of Hire is in C1

(((75*365.25)-(C1-B1))/2)+C1

Taking your years needed and multiplying by 365.25 to get number of days.
You can just use 27393.75, but wanted to show my work...

Take the date of hire and subtract the date of birth from it. This will give
number of days from birth to hire. Take that amount out of your 75 year
calculation. This now normalizes your calculation.

Divide by 2 since we are double counting every day, one for your aging, one
for your working. This will give your number of days from hire to reach your
75 year goal.

Now, just add all these days to your date of hire to show date of goal.

Maybe confusing, but it works.


This is virtually the same as what I posted almost three and a half hours
ago...the OP responded to everyone with the "wrong" answer and not to the
"right" answer (assuming you and I are "right").