Calculating the difference in dates

[sonar]

Hi

Thanks for the info, it works.

I now want to do the following for example

1. DATE EMPLOYED 2003/01/23
2 CURRENT DATE 2004/10/23 (using the function =NOW())

and using the formula:
=DATEDIF(D8,NOW(),"y") & " years, " & DATEDIF(D8,NOW(),"ym") &
months, " & DATEDIF(D8,NOW(),"md") & " days"

I get the output.

I want to ad a third function where

If 3. DATE TERMINATED (todays date entered manually) is 2004/10/23,
ignore calculating between 1 and 2, but calculating dates between 1 an
3.

1. cell D8
2. cell D9
3. cell D11

EG. =(IF cell D11 has a date,(=DATEDIF(D11,NOW(),"y") & " years, "
DATEDIF(D11,NOW(),"ym") & " months, " & DATEDIF(D11,NOW(),"md") &
days"),(=DATEDIF(D8,NOW(),"y") & " years, " & DATEDIF(D8,NOW(),"ym")
" months, " & DATEDIF(D8,NOW(),"md") & " days"))

I need help to write the right formula

Not such a boff!

Thank