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
Kindly refer yellow banner on top of the page.
Attach sample file with required result enter manually.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Have you triedFormula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
=VLOOKUP(today(),Date!D:E,2,0) - today()
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
@telhearne1: You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks