Calculate Retirement Date with EDATE and EOMONTH functions
Learn how to Calculating Retirement Date with EDATE and EOMONTH functions. The rule for calculating the retirement date is:
1. Retirement age is 60 years.
2. Employee retire last day of the month but birth date is the first of the month shall retire on last day of previous month.
3. If DOB 06/03/1963 then retirement date is 31/03/2023
4. If DOB 01/03/1963 then retirement date is 28/02/2023.