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