Formula to capture historical data from data that changes daily
 

I'm hoping somebody out there can help me. Please refer to below scenerio.


TITLE % of Budgeted HOURS Completion %
PROJECT TOTAL 100.00% 90.00%
(the above is updated from 4 other sheets)


SIT Test Time Tracker
Today 28-Dec-05 [using =now()]
Start of Final SIT 9-Jan-06
End of Final SIT 6-Feb-06

[I want Col B and Col C to refernce the "today [=now()]" above and the dates
in their respective rows below to capture the "PROJECT TOTAL" information
above. I can use "IF" but once the "Today" dates change to the following day
the data will be lost and only the currents info will be present. I want to
capture historical data to graph. Thanks for your help in advance!]

Col A Col B Col C
% of Budgeted HOURS Completion %
9-Jan-06 10% 20%
10-Jan-06 30% 40%
11-Jan-06 50% 50%
12-Jan-06 70% 65%
13-Jan-06 85% 75%
14-Jan-06 95% 85%
15-Jan-06 100% 90%
16-Jan-06....