Six types of service calculation and how to do these using Excel

[Richard Purvey]

Calculation of Potential Service In Whole Years for pensions using excel.  Put the date of the first day of service into cell A2 and the Normal Retirement Date into cell B2, and into cell C2, put the formula =DATEDIF(A2-1,B2-1,”Y”)

 

Calculation of Potential Service In Years and Whole Months for pensions using excel.  Put the date of the first day of service into cell A2 and the Normal Retirement Date into cell B2.  Into cell C2, put the formula =DATEDIF(A2-1,B2-1,”Y”) and into cell D2, put the formula =DATEDIF(A2-1,B2-1,”YM”)

 

Calculation of Potential Service In Years and Days for pensions using excel.  Put the date of the first day of service into cell A2 and the Normal Retirement Date into cell B2.  Into cell C2, put the formula =DATEDIF(A2-1,B2-1,”Y”) and into cell D2, put the formula =DATEDIF(A2-1,B2-1,”YD”)

 

Calculation of Actual Service In Whole Years for pensions using excel.  Put the date of the first day of service into cell A2 and the date of the last day of service into cell B2, and into cell C2, put the formula =DATEDIF(A2-1,B2,”Y”)

 

Calculation of Actual Service In Years and Whole Months for pensions using excel.  Put the date of the first day of service into cell A2 and the date of the last day of service into cell B2.  Into cell C2, put the formula =DATEDIF(A2-1,B2,”Y”) and into cell D2, put the formula =DATEDIF(A2-1,B2,”YM”)

 

Calculation of Actual Service In Years and Days for pensions using excel.  Put the date of the first day of service into cell A2 and the date of the last day of service into cell B2.  Into cell C2, put the formula =DATEDIF(A2-1,B2,”Y”) and into cell D2, put the formula =DATEDIF(A2-1,B2,”YD”)

 

Note;

 

Calculation of Normal Retirement Date using excel.  Put the date of birth into cell A2 and the age in years to be added (the normal retirement age, e.g. 60) into cell B2, and into cell C2, put the formula =DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2))

 

 

 

 

 

 

 

 

 

 

[Author]

Posts