View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ewan7279 ewan7279 is offline
external usenet poster
 
Posts: 97
Default 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.