Retrieving information for a day of the week...
 

I am attempting to retrieve information on a daily basis from a list that
sums up the daily using 1 weekly date.

Here's what it looks like, I'm trying to retrieve information he

Oct 3, 05 Oct 4, 05 Oct 5, 05 etc...
Area1 NDH NDH NDH

Here's the table that from where I'm pulling the info:
Area1 Area2 Area 3
Wk of 10/3
Wk of 10/11

So basically the data in Wk 10/3 should be reported on each day from 10/3
through 10/10. How could I do this?

Hopefully, I'm explaining this well.

Thanks!