Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calendar - vlookup based on dates | Excel Worksheet Functions | |||
VLOOKUP calendar dates | Excel Discussion (Misc queries) | |||
VLOOKUP & Dates: Why is this Formula working? | Excel Worksheet Functions | |||
VLookUp with Dates | Excel Worksheet Functions | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions |