Performing Excel functions based on effective/discontinued dates

I have a question that's somewhat similar to the one asked here.

Creating Formula (Effective-Discontinue) Dates while using vlookup

Basically, I have two tables:

1. Historical sales data per item (with sales dates)
2. Items eligible for commission along with effective/discontinued dates

What I need is some way to calculate commission per item into my first table based on the eligible commission items in the second table. The part of my question that differs from the link I provided is that any one of my sales items might have multiple effective/discontinued dates, meaning that item 12345 might be effective 1/1/2015-3/31/2015 and also 4/15/2015-current, so a sale of the item on 4/1/2015 would be ineligible for a commission, but sales on 3/1/2015 and 5/1/2015 would be eligible.

Does anyone have suggestions on formulas I can use and ways to organize my data in table 2 to best facilitate what I'm trying to do? Thanks.