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