Rule of 75 Retirement Calculation
This gives me a date of march/1900. It should be a future date.
"ShaneDevenshire" wrote:
Hi,
Try this
=DATEDIF(A1,TODAY(),"y")+DATEDIF(A2,TODAY(),"Y")
in A1 enter the birthdate, in A2 the date of hire.
If this helps click the Yes button.
--
Thanks,
Shane Devenshire
"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?
|