I have two worksheets:  Report and Weekly Report.  On the report I have the
data listed by days. Some days are five day work weeks and some can be up to
seven day work weeks.

Simple example below
Report
Date                Failures        
12/3                    5
12/4                    6
12/5                    3
12/6                    9
12/7                    10
12/10                   3
12/12                   2
12/15                   1

I want the weekly report to look like this:
Week Of              Failures
12/3                       33
12/10                      6

I want to use macros for these examples.

Thanks