The trick here will be to first determine the dates to pull. After that, you
can simply use the VLOOKUP function (see XL help for full detail) to pull in
the other info.

For the dates, to pull the last seven days, assuming you are entereing dates
as true dates/numbers.

Latest date:
=LARGE(A$38:A$500,ROW(A1))
Copy this down 6 more rows to give you the next 6 most recent dates.

Again, now that you have the dates, you can use that as a lookup value in
the VLOOKUP function.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Buckeye Epstein" wrote:

I have a work sheet with stock data entered every day. I need like
on B15 with the title on A15 Last 7 days volume. The data starts on
A38 with the date, open is on b38, high is on c38, low is on d38,
close is on e38 and volume is on f38. Currenlty i have about 75 days
but would like to set data end at 500 cells. Please help me with
this fomula..

One more request. I would like to have also the last date with
closing price. The cell I would like to place this is A36. So I
need the computer to find the last data of entry from a38:a500 and
then go to that cell - in e38 for the close.

Thanks JBE