View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BAD BAD is offline
external usenet poster
 
Posts: 13
Default 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?