software

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