Calculating Retirement & Age of Retirement

[Turnkey]

I'm just getting started so bear with me. I've just imported a group of employee's who can retire after 25 years of service. I need to calculate the their retirement date and the age they will be when they retire.

Thanks,

T.

[comment]

Try:

DateOfRetirement =

Date ( Month ( DateOfEmployment ) ; Day ( DateOfEmployment ) ; Year ( DateOfEmployment ) + 25 )

AgeAtRetirement = 

Year ( DateOfRetirement ) - Year ( DateOfBirth ) - ( Date ( Month ( DateOfBirth ) ; Day ( DateOfBirth ) ; Year ( DateOfRetirement ) ) < DateOfRetirement ) 

[Vaughan]

I've just imported a group of employee's who can retire after 25 years of service.

And then you deport them?

Sorry, couldn't resist.

[FMPierce]

Here is a calc my dad and I made to calculate experation dates.

Where:

StartDate = date the 25 years starts,

Term_Months = number of months in the term (in your case it would be 300, 25 years times 12 months in a year)

Let ( [

x = Month ( StartDate ) + Term_Months ;

y = Day ( StartDate ) ;

z = Year ( StartDate ) ]

; If ( x > 12 ;

( x - 12 ) & "/" & ( y ) & "/" & ( z + 1 ) ;

( x ) & "/" & ( y ) & "/" & ( z ) )

)

[comment]

Using the Date () function is not only simpler - it also works regardless of the date format in use.