Separating Weeks In An Order List

I order sushi at work for the office, and I want to automate the reporting side of it

this is what the information looks like (bad formatting, sorry) (the notes column is also void currently)

date name order # decscript Price Paid? Notes 1/01/2009 John Smith 10 blah 10 5 Y

Jane Smith 12 blah 12 7 Y

Adam Black 1 blah 1 4 Y

Charles Dee 1 blah 1 4 Y
15/01/2009 John Smith 10 blah 10 5 Y

Jane Smith 12 blah 12 7 Y

Adam Black 1 blah 1 4 Y

Charles Dee 1 blah 1 4 Y

Handel Fee 6 blah 6 8 Y

Gretal Goo 7 blah 7 6 Y
1/02/2009 Adam Black 1 blah 1 4 Y

Charles Dee 1 blah 1 4 Y

Gretal Goo 9 blah 9 7 Y

What I enter is the 1) person's name 2) their order # and 3) wether they have paid (Y/N).
The proper version has a vlookup to fill in the description and price.

What I want to do (but don't know how) is to automatically count the number of orders each week, and the value of each week's orders.

Well, actually I can do the count orders/sum value manually - more specifically I can't work out how to automatically seperate each week. The main problem being there's always an unknown and variable number of orders per week.

One solution is to have a fixed number of orders per week which _sort of_ works, but is clunky and inelegant. Plus the names don't autocomplete then as it has blank spaces.