title: Create list of custom non-standard date formats in excel
body: <p>I have a table in excel with non-standard dates written in four general formats (first column), and would like to convert each to a standard excel date format (2nd column).</p>
  <p>Early 2022 should convert to 01/14/2022
  YE 2022 should convert to 12/01/2022
  2Q 2022 should convert to 05/01/2022
  2H 2023 should convert to 09/01/2023</p>
  <p>Ideally, I would like to use the custom format table and just add these 4 rules but a formula addressing each of the 4 scenarios would also suffice.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Non-Standard Dates</th>
  <th>Converted Dates</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Early 2022</td>
  <td>01/14/2022</td>
  </tr>
  <tr>
  <td>YE 2022</td>
  <td>12/01/2022</td>
  </tr>
  <tr>
  <td>2Q 2022</td>
  <td>05/01/2022</td>
  </tr>
  <tr>
  <td>2H 2023</td>
  <td>09/01/2023</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Most likely, nested IF statements will be required that check for the words &quot;Early&quot;, &quot;YE&quot;, &quot;2Q&quot; and &quot;2H&quot; will be required, followed by amending of last 4 digits.</p>
  <p>I've only figured out how to check for one word, but the IF statements need to be nested. =IF(A2=&quot;Early&quot;, &quot;01/14/&quot;, &quot;&quot; ) works, but of course I need to replace the last portion (&quot;&quot;) with a new IF statement to look for the next phrase (&quot;YE&quot;) and so forth. I also need to amend the last 4 digits.</p>