Hi

I am struggling to find a formula that will work with various date ranges
(that overlap) within a worksheet and return a total value for each date.

E.g.

Table 1

Start Date End Date Value per day in period (start date to end
date)
23/06/2006 22/09/2006 3
23/06/2006 22/09/2006 -39
23/08/2006 26/09/2006 255

I want to return a result that shows the total value for each day across the
entire range of days in a new column

such as

Table 2

Day Total value
23/06/2006 -36 (calculated by -39+3)
24/06/2006 -36
.....
23/08/2006 219 (calculated by 255-39+3)
24/08/2006 219
25/09/2006 255

I will be producing the column "day" in table 2 based on the earliest day
and last day in the range from table 1. I need the formula to compare each
day in table 2 against the date ranges in table 1 and calculate the total
value applicable to each day.

Essentially I am looking for the formula to generate the total value per day
for every day across the entire range of dates.

Any help much appreciated.

Thanks