Help needed on Date formulas
 

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

Date logged P1 bugs P2 bugs Week Logged(Sunday)
[To be calculated
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 counts
for each week,by manipulating the date logged.Irrespective of any date
it was logged,there should be a column which contains the formula,to
find the week in which the bug was logged.Is it possible in Excel ?

Please help.

Shantha


--
shminas
------------------------------------------------------------------------
shminas's Profile: http://www.excelforum.com/member.php...o&userid=33981
View this thread: http://www.excelforum.com/showthread...hreadid=537530

Help needed on Date formulas
 

This formula always returns the previous Sunday (or on a Sunday that
day's date) for a date in A1

=A1+1-WEEKDAY(A1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=537530