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))))

     

Harun24HR's avatar
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))))

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 13, 2025

    It could be modified as

    =TRANSPOSE( FILTERXML("<t><s>"&SUBSTITUTE(A2," ","</s><s>")&"</s></t>","//s[translate(.,'1234567890','')!=.]") )

    but still depends on locale.

Resources