dates and vlookup

I have a formula taking the date a person joined away from today date to give
the number of years works eg 10 and I want to use this value to look up 10 in
the lookup table.
The 10 calculated from the dates is not really a 10 as it a date value
deducted from another date value. How can I convert the 10 derived from
=today()-c7 (where c7 is for example 26/11/95) to a real 10 so that it can
use this value to look up 10 from a look up table

Try:
=ROUND((TODAY()-C7)/365.25,0)
Regards,
Alan.
"grapes" <[email protected]> wrote in message
news:[email protected]...
>I have a formula taking the date a person joined away from today date to
>give
> the number of years works eg 10 and I want to use this value to look up 10
> in
> the lookup table.
> The 10 calculated from the dates is not really a 10 as it a date value
> deducted from another date value. How can I convert the 10 derived from
> =today()-c7 (where c7 is for example 26/11/95) to a real 10 so that it can
> use this value to look up 10 from a look up table