>>Dear All,
>>
>>I have an Excel file (Office 97) containing the starting and leaving dates of all our staff since 96. I would like to be able to add a formula so that I can see how long in months and years each staff member was in the company. Help suggests DAYS360(C2,D2)/360 but this doesn't produce the kind of result I'd like. It gives answers such as 0.82. I would appreciate any help you can give me.
>>
>>Thanks in advance for your assistance.
>>Paula
>
>Convert to text with text(A1, "yyyymmdd"). Then, convert back to numeric. YOu can subtract two of these values, divide by 10000, and get the integer part, for elapsed years.
>
>HTH, Hilmar.

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?

Thanks for your additional help, Paula