Hi All,

Cell K12 =TODAY()
Cell L12 =VLOOKUP(K12,Date!D:E,2,0)


I would like a formula that subtracts todays date from the value of a vlookup.

I have the above formulas, then another to subtract the two values.

I'm sure all 3 can be combined. Can someone please advise what the formula should be?

Many Thanks