How to Take the value of the same date

Hello,

I am getting problem to select a cell value with reference to date range.

Eg:

for preparation of DPR, i need to put date of DPR.
i want to put in following way.

i want prepare a worksheet formula in which in a row there are dates from 1/1/2011 to 31/1/2011, qty done in next row

if today date 1/1/2011, then cell should take value below cell of the same date(1/1/2011),
then if i change todays date as 20/1/2011, cell should take value below cell of the same date(20/1/2011).

plz help me to do this.