Hi,
I am looking for help on a file i am working on...

A B C
Date IN OUT
01/01/06 12 2
03/01/06 3 8
05/01/06 8 0
09/01/06 10 4
15/01/06
...

And I need a formula in D1 to get the total of data in column B between 01/01/06 and 07/01/06, in D2 to get the total of data in column B between 08/01/06 and 14/01/06, etc.

Can someone please help me with this? Thanks in advance.