I mean, I know of a Microsoft product that allows for a batch import of data provided in an Excel file. You need to use their template file. Which, when used, automatically formats all dates the American way, ignoring your locale settings. Depending on which date is first encountered on import (e.g. which date you entered in the first line) then designates whether the whole file is imported with dates read as MM/DD/YYYY or DD/MM/YYYY.

You start your list on January 1st? It will import everything as MM/DD/YYYY then. You start you list on e.g. January 22nd? DD/MM/YYYY it is then. Good luck getting that import running without errors...

[–] CeeBee_Eh@lemmy.world 5 points 1 week ago

MM/DD/YYYY

DD/MM/YYYY

Both of these are the wrong way to format dates.