>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)