Subject: Retirement Date Calculation Request
Dear Sir,
I am seeking assistance with obtaining an Excel sheet for calculating the retirement date for government servants. The basic calculation involves adding 60 years to the individual's date of birth. The retirement date is considered to be the last day of the specific month. In cases where the date of birth falls on the 1st of a month, the retirement date would be the last day of the previous month.
Thank you for your attention to this matter.
Email: b_sivaramakrishnan@yahoo.co.in
Date: 03.03.2009
From India, Madras
Acknowledge(0)
Amend(0)
Dear Sir,
I am seeking assistance with obtaining an Excel sheet for calculating the retirement date for government servants. The basic calculation involves adding 60 years to the individual's date of birth. The retirement date is considered to be the last day of the specific month. In cases where the date of birth falls on the 1st of a month, the retirement date would be the last day of the previous month.
Thank you for your attention to this matter.
Email: b_sivaramakrishnan@yahoo.co.in
Date: 03.03.2009
From India, Madras
Acknowledge(0)Amend(0)
To calculate the retirement date for government servants in an Excel spreadsheet, you can follow these steps:
1. Create a new Excel sheet with columns for "Date of Birth" and "Retirement Date."
2. In the "Date of Birth" column, enter the individual's date of birth in the format DD/MM/YYYY.
3. In the "Retirement Date" column, use the formula "=EOMONTH(A2, 720)" where A2 is the cell containing the date of birth. This formula adds 60 years (720 months) to the date of birth and returns the last day of the month.
4. If the date of birth falls on the 1st of a month, you can adjust the formula to subtract 1 day. For example, if cell A2 contains the date of birth, the formula would be "=EOMONTH(A2, 720)-1".
5. Drag the formula down to apply it to all rows with date of births.
6. Format the "Retirement Date" column to display dates in the desired format.
This Excel sheet will now accurately calculate the retirement date for government servants based on the specified criteria.
From India, Gurugram
Acknowledge(0)Amend(0)
741. Create a new Excel sheet with columns for "Date of Birth" and "Retirement Date."
2. In the "Date of Birth" column, enter the individual's date of birth in the format DD/MM/YYYY.
3. In the "Retirement Date" column, use the formula "=EOMONTH(A2, 720)" where A2 is the cell containing the date of birth. This formula adds 60 years (720 months) to the date of birth and returns the last day of the month.
4. If the date of birth falls on the 1st of a month, you can adjust the formula to subtract 1 day. For example, if cell A2 contains the date of birth, the formula would be "=EOMONTH(A2, 720)-1".
5. Drag the formula down to apply it to all rows with date of births.
6. Format the "Retirement Date" column to display dates in the desired format.
This Excel sheet will now accurately calculate the retirement date for government servants based on the specified criteria.
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Employee excel sheet.xls