Tuesday, March 29, 2016

How to calculate Retirement Date in Excel

For Central Govt Employees for whom retirement is 60 years then Retirement Date can be calculated using formula in excel

=IF(DAY(A1)=1,EOMONTH(A1,719),EOMONTH(A1,720))





For State Govt Employees for whom retirement is 58 years then Retirement Date can be calculated using formula in Excel

=IF(DAY(A1)=1,EOMONTH(A1,695),EOMONTH(A1,696))


No comments:

Post a Comment