Forum Discussion

Bronze Contributor

Nov 12, 2025

Solved

How to extract multiple dates from description?

I have description in column A like below screenshot. How can I extract dates from this strings like right portion?

Thanks for response. I have figured out it as

=LET(x,FILTERXML("<t><s>"&SUBSTITUTE(A2," ","</s><s>")&"</s></t>","//s"),TRANSPOSE(FILTER(x,ISNUMBER(x))))

Harun24HR
Bronze Contributor
Nov 13, 2025
Thanks for response. I have figured out it as
=LET(x,FILTERXML("<t><s>"&SUBSTITUTE(A2," ","</s><s>")&"</s></t>","//s"),TRANSPOSE(FILTER(x,ISNUMBER(x))))
JKPieterse
Silver Contributor
Nov 12, 2025
You can use a formula like this one:
=LET(words,TEXTSPLIT(A2," "),TEXTSPLIT(TEXTJOIN(",",TRUE,IFERROR(DATEVALUE(words),"")),","))
- SergeiBaklan
  Diamond Contributor
  Nov 12, 2025
  That doesn't work with US format (11/01/2015) if we are in another locale.