Hi Al,
I wsa trying to set up a sheet that I htought might look like yours and came
up with this, although I am sure it is much simpler than what you are really
dealing with:

Date "Income
Weeks" Exp1 Exp2 Net
1/7/2005 1 Exp1 Exp2 Net1
1/14/2005 2 Exp1 Exp2 Net2
1/21/2005 3 Exp1 Exp2 Net3
1/28/2005 4 Exp1 Exp2 Net4
2/4/2005 5 Exp1 Exp2 Net5
2/11/2005 6 Exp1 Exp2 Net6
2/18/2005 7 Exp1 Exp2 Net7
2/25/2005 8 Exp1 Exp2 Net8
3/4/2005 9 Exp1 Exp2 Net9
3/11/2005 10 Exp1 Exp2 Net10
3/18/2005 11 Exp1 Exp2 Net11
3/25/2005 12 Exp1 Exp2 Net12
4/1/2005 13 Exp1 Exp2 Net13

This only shows the first quarter and the first week of the 2nd quarter. Is
this similar to how you have your data set up? Then my second question would
be, what is it you want to carry ove to your quarterly report? All of the
detail of each quarter only or the subtotals of the quarter only?

Thanks,
"Al Vanderhoof" wrote:

I have a workbook that has 52 weeks(rows) of income and expenses(columns).
I'm trying to set up a quarterly reports sheet that updates from this info,
but I cannot figure out how to set up the formulas that will find the dates
that are in the range and save the subtotals and totals.
Thanks ahead of time for any help

You are going to have some problems. The Quarters do not break evenly between
weeks. Can you get a hold of the daily amounts. If so then we can set you up
with at pivot table which will automatically subtotal based on weeks, months
, quarters...What ever makes you heart go pitter patter... Otherwise you will
have to break up 4 of your weeks that straddle the quarters.

HTH

"Al Vanderhoof" wrote:

I have a workbook that has 52 weeks(rows) of income and expenses(columns).
I'm trying to set up a quarterly reports sheet that updates from this info,
but I cannot figure out how to set up the formulas that will find the dates
that are in the range and save the subtotals and totals.
Thanks ahead of time for any help