Rule of 75 Retirement Calculation
In A3, you say "put any date you want". What date am I supposed to use here?
"Mike H" wrote:
Hi,
There must be a formula bit I can't see it. Until someone comes up with one
it can be resolved with Goal seek
DOB in A1
DES in A2
Any date you want in A3
This formula in B1 =DATEDIF($A$1,A3,"y")
This formula in B2 =DATEDIF($A$2,A3,"y")
This formula in B3 =Sum(B1:B2)
Select B3 then
Tools|Goal seek
In the 'To value box' enter 75
In the 'By changing' box enter A3
OK and you get your retirement date in B3
Mike
"BAD" wrote:
I need a formula to give me the date of when someone's age and years of
service equals to 75. I have the birth date and the date of hire but have no
idea where to begin. Any suggestions?
|