Home > Software engineering >  How to Extract Date from String in Google Sheets
How to Extract Date from String in Google Sheets

Time:04-17

I have a Google Sheets spreadsheet that contains 1000 rows.

In Column B, I have a text string which contains a date.

Example:

Written by <!-- -->John Doe<!-- --> on <!-- -->Wed Nov 17 2021<!-- -->.

How can I extract Nov 17 2021 from this string?

If it helps: The date always appears between the 2nd to last ">" and the last "<".

I've already checked enter image description here

for a complete column (as B)

=arrayformula(iferror(regexextract(B1:B,"\w{3} \d{2} \d{4}")*1))
  • Related