Need a formula for the weekly sums

[bjkiwi007]

Hello,
I have a spreadsheet with dates listed from the 1st of January through to the 31st of December. I have entries on multiple days with sums and some days have more than one entry whilst others have none. I now need to get the data out in a way that gives me weekly totals. For example I need Week1, week2, week3 and so on. My dates are formatted as follows: [$-407]ddd, d\. mmmm yyyy. Column A is my dates and column B is the data. Could anyone suggest a macro that could maybe help get the result I am after?
Thanks in Advance
BJ

 

[cbzdmh]

Could you not put the data into a Pivot table and group the dates by week?

 

[al_b_cnu]

Hi BJ,

Alternatively, could you add a column 'Week Number', with the formula '=WEEKNUM(cell)'
and then use SubTotals feature?, e.g.

Book1
	A	B	C	D
1	Date	Week Number	Value
2	Thu 01-Jan-09	1	81
3	Thu 01-Jan-09	1	28
4	Fri 02-Jan-09	1	91
5	Fri 02-Jan-09	1	47
6	Fri 02-Jan-09	1	29
7	Sat 03-Jan-09	1	84
8		1 Total	360
9	Mon 05-Jan-09	2	67
10	Tue 06-Jan-09	2	21
11	Wed 07-Jan-09	2	19
12	Thu 08-Jan-09	2	36
13	Fri 09-Jan-09	2	70
14	Sat 10-Jan-09	2	25
15		2 Total	238
16	Sun 11-Jan-09	3	59
17	Mon 12-Jan-09	3	49
18	Tue 13-Jan-09	3	22
19	Wed 14-Jan-09	3	87
20	Thu 15-Jan-09	3	34
21	Fri 16-Jan-09	3	5
22	Sat 17-Jan-09	3	61
23		3 Total	317
Sheet1

 

[bjkiwi007]

Thanks. I used the Sub totals option and it worked fine. thanks for all your help.
BJ