Hi guys,

I need some help from formula experts and attach a small sample for your reference.

The dates when each order is received and when it is completed and despatched are logged in column A & B respectively.

I want to count the number of outstanding orders in each day. Any orders which are completed on same date are excluded. My sumproduct formula in column F needs to be modified to include items without a completion date in column B as well.

Thanks in advance.

Regards


kp