title: How to find if a date for a particular ID falls within multiple date ranges
body: <p>I have a set of transaction data - promotion if and date of sale. In another sheet i have a list of promotions and the days on which they were run.</p>
  
  <p>I want to know if for a transaction carrying a certain promo id on a give date really had a promotion or not.</p>
  
  <p><a href="https://i.stack.imgur.com/zMMTY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zMMTY.png" alt="enter image description here"></a></p>
  
  <p>Is it possible to check for this either using formulas or vba.</p>