Weekly Max Formula

I’m working on creating a new sheet with my boss. We are trying to take results generated daily and from them calculate the “weekly max.”

The weekly max is basically the highest result in our data set from a given week. A week starts Sunday and ends Saturday.

Here is the difficult part for us: we don’t want to use results from weeks that cut through the beginning/end of months. For example: September 29th is a Sunday, denoting the beginning of a week, Monday the 30th is the last day of the month, so we don’t want these two results to be considered in our calculation. Likewise the following month in October, we won’t take results from 1st through the 5th, or the 27th through the 31st.

Can anyone help me with this formula?

Thanks for reading!