converting daily data to weekly

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

If you're looking to return the maximum value in a range then use the MAX function.

If A1:A5 = the values for a date range (say week 1),

then this formula will return the highest value in that range.

=MAX(A1:A5)

i know the max function, but my problem is that i have a lot of data, and to manually go through to find the range (i.e the dates of the week) would be impossible. is there someway to automatically determine the start and end of a week, even if some weeks end on friday and some end on thursday?

Possibly you could also use a Pivot Table or DMAX with date criteria.
See attached.

thank you, this worked great. i appreciate it

Be sure to mark your thread as solved.

Which solution of those offered met your requirements?

i also have to find the min value for each week, so i tried using the same formula but with min instead of max, but i get 0 as my answer every week. any thoughts?

and sorry, it was martindwilson's reply that i used