The following table stores the event memo information:

For the convenience of future statistics, we want to extract all the date data from each row, and put them in the next column after separating by semicolon, like this:

Enter in cell B1:

=spl("=?1.split("" "").(date(~,""dd.MM.yy"")).select(ifdate(~)).concat("";"")",A1)

Then drag B1 down to every relevant row.

Split the string with spaces to form a sequence;
Convert the text string in the sequence to the date type data according to the specified format;
Select the date type data and concatenate them into a string with semicolon.

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1659154176907
https://c.scudata.com/article/1659236901556