Finding highs lows for a stock price data (weekly)

HI TO EXCEL FORUM

HIGH LOW.xlsx

the excel file consists of stock price data with OPEN HIGH LOW

for a weekly data one can find OPEN and CLOSE using VLOOKUP function.

but for finding highs and lows for multiple weeks, using MAX & MIN is becoming painful method.

finding every week high and lows for data of more than 2000 data points is becoming painfull task

can anyone give me formula to calculate the highs and lows and a method to copy it down the cells ??

HIGH LOW.xlsxHIGH LOW.xlsx

In the above excel sheet i added date, we can find open and close using vlookup function.

but for finding the highs and lows (weekly) for more than a week, the work is becoming difficult.

so help me on this task