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))
=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