I have a list of dates to import into excel which, if the month is less than
13, becomes the day, and vice versa.

So, if my original date was 1st October 2008, the export result in excel is
10/01/08.
If my original date was 1st April 1999, the result is 4/01/99.

Rather than quibble about the program that does this to my data, does anyone
have a formula/solution I could apply that I could apply to a list of dates
and it would "flip around" so the month becomes month again, day becomes day.
Note: List also has normal dates with months 12, those dates are correct
because the export recognises that there are no months beyond 12.

(Apologies if this has come up before, or if you can direct me to a previous
solution, that would be fine!)