Macro For Excel

I got a list in excel with numbers for each day since 1978 to 1989.
I need a macro to find the minimun and maximum for each week and fill in the weekly table. Then a similar macro to search for the monthly min./max. and fill in the monthly table.