I am trying to come up with a formula that will calculate projected usage as
dates change. Example I want a formula that would say that in the first 3
time periods below "using todays date as the reference point(1 June foe
example) group all projected usage for the next 3 weeks." The desired result
is 3 below. Then lets say that a week later (June 8) the same formula would
return a result of 4 (the expected usage for the time period covering 8 June
to 22 June) any suggestions?


6/1/2007 6/8/2007 6/15/2007 6/22/2007 6/29/2007 7/6/2007
1 1 1 2 1 1

--
Clark

(assume 6/1/2007 is cell A1)

row 1 -- 6/1/2007 -- 6/8/2007
row 2 -- 1 -- 1
row 3 - =A2+B2+C2 -- =B2+C2+D2 -- and so on...

Copy this formula (=A2+B2+C2) to the right (adjacent cells).



"Clark" wrote:

I am trying to come up with a formula that will calculate projected usage as
dates change. Example I want a formula that would say that in the first 3
time periods below "using todays date as the reference point(1 June foe
example) group all projected usage for the next 3 weeks." The desired result
is 3 below. Then lets say that a week later (June 8) the same formula would
return a result of 4 (the expected usage for the time period covering 8 June
to 22 June) any suggestions?


6/1/2007 6/8/2007 6/15/2007 6/22/2007 6/29/2007 7/6/2007
1 1 1 2 1 1

--
Clark

Hi Clark

Try
=SUMPRODUCT((A1:F1=TODAY())*(A1:F1<=TODAY()+14)*A 2:F2)

--
Regards

Roger Govier


"Clark" wrote in message
...
I am trying to come up with a formula that will calculate projected
usage as
dates change. Example I want a formula that would say that in the
first 3
time periods below "using todays date as the reference point(1 June
foe
example) group all projected usage for the next 3 weeks." The desired
result
is 3 below. Then lets say that a week later (June 8) the same formula
would
return a result of 4 (the expected usage for the time period covering
8 June
to 22 June) any suggestions?


6/1/2007 6/8/2007 6/15/2007 6/22/2007 6/29/2007 7/6/2007
1 1 1 2 1 1

--
Clark