On Oct 4, 12:27 pm, sharmashanu wrote:
ok..to get the first seven days..use this formula in column 1

=IF(DAY(Sheet1!A2)<7, Sheet1!A2, "")

if you want the past 7 days then use the one i gave before

=IF((Sheet1!A1-TODAY())<=7, Sheet1!A1, "")

To get the second row use
=(VLOOKUP(A1,Sheet1!A2:E6,2,FALSE)) this will give second column
correspoding to that date

to get the third use

=(VLOOKUP(A1,Sheet1!A2:E6,3,FALSE)) and so on.

hope this helps

Won't a vlookup only work if the column is sorted in order? It isn't
and can't. I'm still stuck. Thanks so far though... -Rob