title: Excel Formula which will add either this year, or next year to a fixed date (e.g. 1st October), dependent upon whether that date has passed this year?
body: <p>I understand if I want to enter a fixed date and use the current year I can use the following formula:</p>
  <pre><code>=DATE(YEAR(TODAY()), 10, 1)
  </code></pre>
  <p>But after the 1st October this year I want the formula to be for next year instead:</p>
  <pre><code>=DATE(YEAR(TODAY())+1, 10, 1)
  </code></pre>
  <p>How can I automate this in excel so that I don't have to manually amend this when the 1st October passes? I need to avoid referencing any other date cells in my spreadsheet.</p>
  <p>Thanks to anyone that can help.</p>