I noticed that =DATEVALUE() behaves different in the online version of Excel 365 (i.e. it does not work) than in the local version of Excel 365 on my PC. Below are two screenshots of the two Excel Versions.
Any idea on how I can get the formula to work in both Excel versions? I cannot use VBA, unfortunately.
(I used "TT.MM.JJ" as the text_format parameter, as my local Excel is set to German)