need an advice in excel sheets....
 

hi!
I am preparing a basic calculator for myself for some funds and I got into a
trouble...
there is a excel file U can download...
http://www.andergrant.com/problem.zip

so..
"a, b, c, d, e, f" sheets are the names of funds
the problem is in the sheet called 'main' in the cell F109. I want this cell
to feedback me the number taken from sheet 'a' from the row number 4 BUT
!!! - I WANT IT TO FEEDBACK IT FROM TODAY!!! (I want to query to
compare/check today's date and answer with a proper number under the today's
date).
So the feedback for such a query for today (2004-11-27) should be 5049,92.
If today's would be 2004-11-22 the feedback for sheet 'a' would be 5050,11 -
I hope U are enable to see it...

Please give me a hand with it - I would be very thankfull

thx.up front
m.