title: How to apply if/else logic in python for an excel file? (dates)
body: <p><em><strong>strong text</strong></em>I got an excel file with dates, starting from 2019 till 2021. And i wanted to apply certain rules like if sales was made between 04.05.2019 and 09.05.2019 then it's a promo number 1, etc.  The output is here</p>
  <p><a href="https://i.stack.imgur.com/YdtJv.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YdtJv.png" alt="enter image description here" /></a></p>
  <p><strong>desired outcome</strong></p>
  <p><a href="https://i.stack.imgur.com/PS82O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PS82O.png" alt="enter image description here" /></a></p>
  <p>Promo file
  <a href="https://i.stack.imgur.com/5KcUD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5KcUD.png" alt="enter image description here" /></a></p>