How about some examples with salariesdate desireddoband expected answer.

--
Don Guillett
SalesAid Software

"Pasty" wrote in message
...
This is great thanks - just a quicky - is there anyway to make it
calculate
each one to 2 decimal places - or is this not possible? (Forgot to mention
that bit sorry!)

"Bob Phillips" wrote:

=DATEDIF(E2,MAX(DATE(YEAR(B2)+41,MONTH(B2),DAY(B2) ),E2),"Y")

and

=DATEDIF(MAX(DATE(YEAR(B2)+41,MONTH(B2),DAY(B2)),E 2),TODAY(),"Y")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Pasty" wrote in message
...
Salary DOB Age Date Date of employment 7.5% 10%


Hi there I have the above headings (Columns a-g) what I need it to do
is
when employees are over 41 their pension increases to 10% rather than
7.5%
so
what it needs to do is give a number in 7.5% for how long they've been
in
employment and below 41 years old and how long they've been in
employment
and
41 and above.

Can anyone help?