View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Rule of 75 Retirement Calculation

Glenn wrote:
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?


Birth date in A1, hire date in A2

=(27394-(A2-A1))/2+A2



Don't forget to format the result as a date.