Hi guys,

I am trying to use a formula or I may need to create a macro to help me solve this problem but here goes:

I have a dataset that has products sold by date. Each product has a different delivery day and as a result I need to calculate the number of products sold in between the delivery dates. E.g. the delivery date is Monday and therefore need to calculate how many products were sold between the two Monday's. I wanted to know if there was a formula that would detect the delivery days and than calculate the sum between the two days. I have one table with the sales per day over a two week period and than another table with 1's on the day of delivery but I'm stuck on how to construct the formula.

Thanks guys