Google Sheets - Parsing
From given text, how do you extract the date?
| Given text | Extracted date (to be generated) |
|---|---|
| Graduation reunion on Saturday, September 10, 2022 at 123 Front Street | September 10, 2022 |
| BBQ Party on Sunday October 1, 2022 at 213 South Street | October 1, 2022 |
CodePudding user response：
try:
=INDEX(IFNA(REGEXEXTRACT(A2:A, "(\w \d , \d{4})")*1))
