Actually Excel is smart here. It knows that Germany uses dots, but slashes are usually an indicator for the US. So you enter mm/dd/yyyy and it comes out as dd.m

Actually Excel is smart here. It knows that Germany uses dots, but slashes are usually an indicator for the US. So you enter mm/dd/yyyy and it comes out as dd.mm.yyyy. (you see, you entered it flipped in your described experience). The easiest way for me is to enter it yyyy-mm-dd in a date formatted column and it will always catch the correct date. I feel the pain with the function names. I know some in German and some in English, because I just switched to the native language at some point. But the translations are easily findable in the web [1] and there is even a built in function translator tool [2]. [1] https://www.excel-function-translation.com/index.php?page=english-german.html https://www.excel-function-translation.com/index.php?page=en... [2] https://support.office.com/en-us/article/excel-functions-translator-f262d0c0-991c-485b-89b6-32cc8d326889 https://support.office.com/en-us/article/excel-functions-tra...