>>Dear Hilmar,
>>
>>Thank you for your response. I'm sorry to be asking what are probably very basic questions but could you please explain the last bit some more. I understand the first bit. C3 = 16/11/1994 --> 19941116 using the above formula. E3 became 19960131. But when I subtract one from the other (E3-C3) I get 1.9015. How can this read as months and years?
>
>Not months and years, only total elapsed years - if you round it.
>
>Months seems more complicated than I thought at first. It seems you a little more complicated - I may have been to quick to give only a partial answer. Let me see...
>
>How about getting total elapsed months first. The following formula seems to work, but you should try it under different conditions:
>
>
>=int((year(E3)*12 + month(E3) + day(E3)/100)
> - year(C3)*12 + month(E3) + day(E3)/100))
>
>
>From this, you can get the year and month with int() and mod() functions.
>
>Well, this is more complicated than I thought at first.
>
>HTH, Hilmar.
Thank you so much for this new formula. I just had to change the last two E3 references to C3 but then it worked wonderfully. I've now plotted the data on a graph and it is very clear to see how many years each staff member has stayed by using gridlines at each 12 month mark. Thank you again for your help on this. I really appreciate it.
Paula