Date calculation (If then type)

[andyman]

Looking for a way to caluculate some retirement information.
Is there a formula that will calculate someones age, and if they are X
age, then check another value (date left company) to then calculate the
years and months of service.

Example
Joe Blow- Birth date 5/10/53
Started with company 8/31/75
Left Company 3/15/03

So if they are 50 years of age, based on current date TODAY () then
check how many years of service, and if over 10 years take value from a
cell.

 

[Biff]

Hi Andyman!

Do you want the result of this formula to be based on just
*years* of service or *years and months* ?

And what about the age? Do you mean greater than or equal
to 50 yrs of age ?

Here's an example using the >= 50 yrs of age and total
*years* of service

=IF(DATEDIF(B3,TODAY(),"y")>=50,IF(DATEDIF(B4,B5,"y")

=10,E3,"NA"),"NA")

It will return the value in E3 if both conditions are true
and NA, if false.

Biff

 

[andyman]

Years and months if possible, so something like 10 years 6 months.

Age would be greater than or equal to 50.

Here is an example of what I have in the spreadsheet. The ones with n
Separation are still employed.

Birth Date Entry Date Separation

12/2/1962 6/1/1981 9/1/1998
6/7/1947 9/1/1978
1/25/1970 12/1/2000
1/6/1967 3/1/2001 3/6/2002
4/18/1958 12/1/2000 1/24/200