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

dates and vlookup
 

Try:
=ROUND((TODAY()-C7)/365.25,0)
Regards,
Alan.
"grapes" wrote in message
...
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