Ok I got confuse. So I need a helper column using WEEKNUM formula. I
thought this is a shorter way to sum up by weeks. Meaning if I have a
list of dates in column C of 2 years and cell E1 is the cell that
represent of the week number and column B contains the vaules. All i
have to do is to change the week number in cell E1 say week *2* then
the formula will sum up all the dates for the past 2 years that falls
on week 2. I do have a long formula for that but dummie me
But I thought that was the shorter version.

sorry about that.


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=514208