Delivery number for all dates in delivery period
 

Hi,

I have a table containing details of deliveries and the periods over which
they apply. I have another table that has all days for 2007 listed down the
left hand side. I am trying to work out a formula to show the delivery
number for each day in the delivery periods. I have found that SUMIF can
give me the delivery number for the start and end dates, but cannot work out
how to do the same for the days in between.

Any ideas please?

Thanks,

Ewan.