Delivery number for all dates in delivery period

=?Utf-8?B?ZXdhbjcyNzk=?=

Guest

Posts: n/a

22nd Jan 2007

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.

« Excel VBA tech interview | RE: delete dynamically created combo box »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Overdue Delivery Dates	Kelly_Durden	Microsoft Excel New Users	5	31st Jan 2008 09:06 AM
MAPI - Correlate sent mail with delivery and non-delivery receipts	=?Utf-8?B?U2Fua2Fy?=	Microsoft Outlook Form Programming	0	18th May 2006 01:29 PM
If you use Microsoft Exchange Server, you can delay delivery of anindividual message. Everyone can use rules to delay delivery of all the messagesby having them held in the Outbox for a specified time after clicking Send.	34345445	Microsoft Access	0	3rd Mar 2006 01:12 AM
Delivery note or delivery order sheet	=?Utf-8?B?Um95IElzdGFuYm91bGk=?=	Microsoft Excel Misc	1	21st Jan 2005 05:31 PM
How can I calculate the number of days between two delivery dates?	Kim Streker	Microsoft Access Reports	6	26th Feb 2004 05:53 AM