Forum Discussion

Harun24HR's avatar
Harun24HR
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?  
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    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's avatar
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's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 12, 2025

    That doesn't work with US format (11/01/2015) if we are in another locale.

Resources