this is my first time posting and i am relatively new to excel...

i have data on a daily basis (based on business days) going back a while. for most weeks, there are 5 days (mon to fri), but in some weeks, the markets were closed on either a friday or monday so the week only consists of 4 days.

i need to calculate the highest daily price for each week (whether that week is four days or five days). here's an example:

Date (day of week) Price
1/1/90(M) 96.5
1/2/90(T) 97
1/3/90(W) 96
1/4/90(Th) 97.6
1/5/90 (F) 97.2
1/8/90(M) 98
1/9/90 (T) 97.4
1/10/90 (W) 97.8
1/11/90 (Th) 96.9
1/15/90 (M) 98.3
.
.
.
.

So what i am looking for is a way, preferrably not VBA, to calculate the highest price of the past week. So in my example, for the week started 1/1/90, the number i should get is 97.6, and for the week started 1/8/90, i should get 98.

This may be a stupid question, but i would greatly appreciate any help i can get. Thank you