Calculating With Dates

[Clark]

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

 

[Badrul]

(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).

 

[Roger Govier]

Hi Clark

Try
=SUMPRODUCT((A1:F1>=TODAY())*(A1:F1<=TODAY()+14)*A2:F2)