I have a lot of exports in which dates are formatted as “dd.mm.yyyy.” While DATEVALUE doesn’t work in Excel anymore with this format, it works in Calc.