That formula is nothing like the formula I suggested.
In post
#15 you quoted my formulas from post
#8 so that is what I modified. Post
#8 went with the qualification that there was always 10 characters after the date. Post
#17 is the first sample data that does NOT have 10 characters after the date - there are now 11, so not too surprising that my formula didn't give the result you expected, but it does not give an error, it returns null strings (appearing as blank cells).
So, if the number of characters after the date can vary (you have never stated that) we must return to my suggestion from post
#7 .
The modifications to those formulas would be
Split Dates (5)
| B | C | D |
1 | Description: | Start | End |
2 | cre fee 07.01-06.02.2018_DSL_555601 | 7/01/2018 | 6/02/2018 |
3 | depot fee 14.01-13.02.2018_DSL 545412 | 14/01/2018 | 13/02/2018 |
4 | withdraw fee 09.01-08.02.2018_DSL 585230 | 9/01/2018 | 8/02/2018 |
5 | deposit april_DSL_A52523 | | |
6 | credi fee 01.01-31.01.2018_DSL 907587 | 1/01/2018 | 31/01/2018 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 299px;"><col style="width: 97px;"><col style="width: 91px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas |
Cell | Formula | C2 | =IFERROR(DATE(MID(B2,FIND("-",B2)+7,4),MID(B2,FIND("-",B2)-2,2),MID(B2,FIND("-",B2)-5,2)),"") | D2 | =IF(C2="","",SUBSTITUTE(MID(B2,FIND("-",B2)+1,10),".","/")+0) |
<tbody>
</tbody> |
<tbody>
</tbody>
Excel tables to the web >> #8 00040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4