For example, I have a list of persons’ birth date, if their retirement age is 60, the following formula can help you to calculate their retirement date, please do as this: 1. Enter this formula: =IF(DAY(E2)=1,DATE(YEAR(E2)+60,MONTH(E2),0),DATE(YEAR(E2)+60,MONTH(E2)+1,0))...How do you calculate retirement benefits?
Your retirement benefit is based on a formula that pays a lifetime monthly benefit. Your benefit is calculated by multiplying three factors: Age factor, determined by your age at retirement. Total earned and purchased service credit.