Possible IF code for Date ??

[ipbr21054]

Hi,
For some time now & still unable to find the cause im asking if there is a vba code etc for which will check & alter the date.

The worksheet is called DATABASE
The date will always be in column N
The first row this applies to is Row 5

My issue is sometimes i paste or typr the day like so into the cell 09/02/2023
For some reason its changed to 02/09/2023

Its not always noticed at first but then sometime down the road when checking a customers file then its noticed.
Example.
My database shows the part being out of warranty but when the customer shows me the receipt the date is different.
Looking on the databse then confirms he is correct & my date in the column is wrong.

Hence why a code that if the date in column N is MM/DD/YYY then change it to DD/MM/YYY

Thanks please advise

 

[ipbr21054]

Sorry im lost with the.
Currently looking through modules