Extrapolate dates and sort

[wildturkey]

Afternoon All

Help if you can please

I'm looking to extrapolate the dates (In bold) from a cell containing the following, there could be around 100 dates...I'd either then like the oldest date returned or, even better the whole set of dates provided horizontally to the cell, one date per cell and sorted in date order, am I asking too much? UK based using UK date format but software file imported using yymmdd..

241201|100001(2454),241201|100002(1270),241201|100003(150),250101|100004(144),250101|100005(588),250101|100006(1377),250201|100007(1620),250201|100008.......................................

Many thanks

 

[FormR]

Hi, here's one option you could try.

Book2
	A	B	C	D	E	F	G	H	I
1	241201|100001(2454),241201|100002(1270),241201|100003(150),250101|100004(144),250101|100005(588),250101|100006(1377),250201|100007(1620),250201|100008	01/12/2024	01/12/2024	01/12/2024	01/01/2025	01/01/2025	01/01/2025	01/02/2025	01/02/2025
Sheet1

Cell Formulas
Range	Formula
B1:I1	B1	=LET(TS,TEXTSPLIT(A1,{"|",","}),SORT(0+TEXT("20"&CHOOSECOLS(TS,SEQUENCE(COUNTA(TS)/2,,,2)),"0000-00-00")))
Dynamic array formulas.

 

[wildturkey]

That works brilliantly for the oldest date - thank you

 

[FormR]

Hi, it should be returning all the dates, not just the oldest.

 

[wildturkey]

Just the one...

250101|100001(3),250101|3(1),250201|1(584)	01/01/2025
250101|100001(113)	01/01/2025
250101|1(154),250201|2(330)	01/01/2025
250101|1(140),240101|100001(2)	01/01/2025
241201|100004(123),250101|100003(50),250101|100005(48),250201|100007(467)	01/12/2024
241201|100001(64)	01/12/2024
241201|100001(28)	01/12/2024

 

[FormR]

Hmm, not on my side..

Book2
	F	G	H	I	J
24	250101|100001(3),250101|3(1),250201|1(584)	01/01/2025	01/01/2025	01/02/2025
25	250101|100001(113)	01/01/2025
26	250101|1(154),250201|2(330)	01/01/2025	01/02/2025
27	250101|1(140),240101|100001(2)	01/01/2025	01/01/2024
28	241201|100004(123),250101|100003(50),250101|100005(48),250201|100007(467)	01/12/2024	01/01/2025	01/01/2025	01/02/2025
29	241201|100001(64)	01/12/2024
30	241201|100001(28)	01/12/2024
Sheet1

Cell Formulas
Range	Formula
G24:I24,G28:J28,G26:H27,G25,G29:G30	G24	=LET(TS,TEXTSPLIT(F24,{"|",","}),SORT(0+TEXT("20"&CHOOSECOLS(TS,SEQUENCE(COUNTA(TS)/2,,,2)),"0000-00-00")))
Dynamic array formulas.

 

[wildturkey]

Sorry, I'd entered as an array, works perfectly!