title: Solving a date cycle formula
body: <p>I am working on the following formula:</p>
  
  <pre><code>=IF(AND(A1="Semi",A2="Japan",MONTH($A$3)&lt;4),DATE(YEAR($A$3),3,31),IF(AND(A1="Semi",A2="Japan",MONTH($A$3)&gt;3),DATE(YEAR($A$3),9,30)))
  </code></pre>
  
  <p>and basically I am trying to find the best formula for a problem I have. In cell <code>A3</code> of my spreadsheet I have today's date <code>=TODAY()</code>. So let's assume today's date is January 1, 2015. What I want the formula to do is the following:</p>
  
  <ol>
  <li>If today's date is before March 31, 2015 then I want the formula to give me March 31, 2015.</li>
  <li>If today´s date is past March 31, 2015, then I want the formula to give me September 30, 2015.</li>
  <li>However, if today's date is past September 30, 2015 then I want the formula to give me March 31 for the following year (i.e. March 31, 2016).</li>
  </ol>
  
  <p>I have worked out a formula which satisfies points 1 and 2, but my formula fails to satisfy point 3.</p>