View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BAD BAD is offline
external usenet poster
 
Posts: 13
Default Rule of 75 Retirement Calculation

same deal here...This gives me a date of march/1900. It should be a future
date.

"~L" wrote:

I think with the person's name in column A, birthdate in column B, and hire
date in column C and row 1 containing headers, in column D row 2:

=(2*Today()-B2-C2)/365.25

gives you what you are looking for.

"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?