title: Fiscal year starts in April but I want to use ISO week numbers 14 of 2018 calendar year to week 13 of 2019 calendar year
body: <p>I am creating a gantt chart in excel for my plan. My formula determines the start week number and end week number, and displays "1" in a cell corresponding for each week number in a timeline. My challenge is how to use this logic when my fiscal year starts in April 2018 and ends in April 2019. If my timeline starts, say in week 46 of 2016 and ends in week 10 of 2019, my formula does not work. 
  Here is the formula I am using: </p>
  
  <pre><code>=AND(K$7&gt;=$H9)*(K$7&lt;=$I9)*1  
  </code></pre>
  
  <p>where K7 is my week number in a timeline, H9 = start week, I9 = end week. See the picture.</p>
  
  <p><a href="https://i.stack.imgur.com/Vhqs0.png" rel="nofollow noreferrer">this is a fragment of my timeline</a></p>