title: RegEx get last match of a date format from string inside a Google Sheets cell
body: <p>My objective is to extract a date string and following characters using Regex in Google Sheets (sheets function: regexextract) where the string is the last line of a cell and starts with a date format "yyyy-DD-MM" followed by ":".
  So the RegExpression that I currently have looks like:
  <code>\d{4}-\d{2}-\d{2}:.+</code>   </p>
  
  <p>This works fine but it returns the first match. Instead I want to start at the end of the cell and extract the last match when there are multiple date strings.  This is because the contents are stored ascending by date inside the cell.</p>
  
  <p><strong>Sample cell:</strong></p>
  
  <pre><code>2020-05-20: Status update blah blah
  2020-05-27: PO Issued blah blah
  </code></pre>
  
  <p><strong>Result requested:</strong>
  I want the end result to be a string starting with date and the characters that follow "2020-05-27: PO Issued blah blah" which is the last result. However I always get the first match which in the example above is: "2020-05-20: Status update blah blah"</p>
  
  <p>Also I'm doing this in google sheets using regexextract() <em>which shouldn't make a difference in the regex but just wanted to mention it</em>.</p>
  
  <p><strong>Edit:</strong> I found out Sheets is using RE2 so I guess it did make a difference.</p>