Say you have the dates in column A and some data in column C. In B1 enter:

=WEEKNUM(A1) and copy down. Here is an example for February 2008:

2/1/2008 5 18
2/2/2008 5 47
2/3/2008 6 46
2/4/2008 6 30
2/5/2008 6 19
2/6/2008 6 44
2/7/2008 6 27
2/8/2008 6 39
2/9/2008 6 37
2/10/2008 7 47
2/11/2008 7 21
2/12/2008 7 11
2/13/2008 7 17
2/14/2008 7 38
2/15/2008 7 29
2/16/2008 7 39
2/17/2008 8 13
2/18/2008 8 19
2/19/2008 8 25
2/20/2008 8 15
2/21/2008 8 49
2/22/2008 8 34
2/23/2008 8 30
2/24/2008 9 26
2/25/2008 9 43
2/26/2008 9 37
2/27/2008 9 34
2/28/2008 9 35
2/29/2008 9 24

since the weeknumber is explicitly available as a column, to calculate the
sum of column C for week #8, use:

=SUMPRODUCT(--(B1:B44=8),(C1:C44))

--
Gary''s Student - gsnu200771


"Hernan" wrote:

Hello,

I have a sheet in which I have the rows labeled from 1 to 31 for each day of
the month, and several columns labeled as intakes, exits etc.

my problems is that I need a *weekly* count of those categories, and each
month does not exactly start on a monday nor that monday being the 1st of the
month. :-)

Each month I start the sheet from a not filled, but formatted and protected
sheet. where all I have to do is change the appropriate cell to reflect the
month and year in course.

Can anyone help me with suggestions as I have been doing this manually and I
have the hunch it can be done easier.

I use Office 2003.

TIA

Hernan