Help creating a COUNTIF formula that will match between dates

Hi all,

I'm trying to build a formula that will count all the 'X's on the second data sheet for the appropriate TM# between the specific dates (Last Date Worked & Return Date)

The answer to this will go in the collumn titled "VC Days Scheduled". So for example, TM #45225 has X's between 5/30/2016 to 6/3/2016, which falls between his "Last Date Worked" (05/13/2016) and his "Return Date"(6/10/2016)...

So it should return the answer "5" for that specific TM.

Any help would be appreciated! I am guessing a Countif would be in order for this type of scenario.

Thanks in advance