function help for golf scores

Hi,

I run a golf league and want to create a scoresheet in excel.
I am looking for a function or formula that will look back at the last 6 weeks scores and drop the highest 2, then calculate an average of the other 4.

Example:
week 1 week 2 week 3 week 4 week 5 week 6
Mike 45 41 46 50 46 48

If we were to drop week 4 and 6, the avg score would be 44.5

For the first 5 weeks we use the scores from the prior year, and would manually enter them.

Thanks in advance!
Mike
[email protected]