Value returned from Formula changes with the Date
I have an issue and I am not quite sure how to solve it.
I have a table, for the purposes of this example
Column #1 = Names of People
Column #2 = Value I am looking for
Row #1 = Date Values 12/1, 12/2 etc.
Rows 2-10 values 46,50,60 etc.
I would like a formula that based on todays date return the value in the
column associated to that date to column #2
the expected result would be that on Day 1
Column 3 = 12/1 values in Column 3 are the values displayed in Column 2
On Day 10
Column 13 = 12/10 and values from column 10 are the values displayed in
column 2 without any interaction from me, the lazy user.
Using the Today() function to set the day to look for seems right but I
can't get the rest.
Thanks
--
Jeff
|