Hi,
I need to keep track of weekly bug counts on a periodic basis.Her
is an example

Date logged      P1 bugs     P2 bugs   Week Logged(Sunday)
[To be calculate
using formula]
01/02/2006         2             3            01/0/12006
01/05/2006         3             5            01/01/2006
01/10/2006         5             5            01/10/2006

In Excel,I would like to find out using formulas, the exact bug count
for each week,by manipulating the date logged.Irrespective of any dat
it was logged,there should be a column which contains the formula,t
find the week in which the bug was logged.Is it possible in Excel ?

Please help.

Shanth