title: How to extract only date from Google Sheets cell
body: <p>I'm trying to extract only the date from this cell which says: <code>Current day (1 Nov 2019)</code>
  Using: </p>
  
  <pre><code>=regexextract(concatenate(FullReport!B5),".*Current day(.*)")
  </code></pre>
  
  <p>Can't seem to figure out how to remove the brackets <code>( )</code> which I believe is causing it to not register in google sheets as an actual date.</p>