Your question is not clear.

What I got -
If value is <2 then take it as 2...
take average of values for days 1-7, 8-14, 15-21, 22-29 and then find the
maximum of these four values, right?

"JD" wrote:

A1-A31 corresponds to days of the month. 3 to 4 times a week lab data is
entered into the corresponding cells B1-B31, some are less than values (<2).
I want to calculate the maximum weekly average, i.e. the highest value of the
4 or so weekly averages and put it at the bottom of the column. I don't want
a column or cell of weekly averages and the <2 values should be counted as 2.

A1 2
A2 2
A3
A4
A5
A6 <2


A8 6
A9
A10 2
A11
A12 <2
A13
A14 2

Answer = 3 (for this 2 week period)

Thanks

--
JD