title: Auto increment a invoice number using Google sheets formula
body: <p>I have an invoice numbering in the format</p>
  <pre><code>SMGS/20-21/COU-07
  SMGS/20-21/COU-08
  SMGS/20-21/COU-09
  SMGS/20-21/COU-10
  SMGS/20-21/COU-11
  </code></pre>
  <p>When my cell A7 has <code>SMGS/20-21/COU-11</code>, how do I generate the next number as <code>SMGS/20-21/COU-12</code> in B7 cell using Google Sheets formula?
  Where the 20-21 year is also auto generated. After March 31, the year shall become 21-22.</p>
  <p>I have tried with <code>=split(B4,&quot;-&quot;)</code></p>
  <pre><code>=IF(MONTH(TODAY())&gt;3,YEAR(TODAY())&amp;&quot;-&quot;&amp;RIGHT(YEAR(TODAY())+1,2),YEAR(TODAY())-1&amp;&quot;-&quot;&amp; RIGHT(YEAR(TODAY()),2))
  </code></pre>
  <p>this displays 2020-21, But I need 20-21 .</p>