Excel date format fix

formula to reformat date from

Either set regional and language options to match the format

OR

DD/MM/YYYY to MM/DD/YYYY

OR
MM/DD/YYYY to DD/MM/YYYY

=(SUBSTITUTE(MID(C3,FIND(“/”,C3)+1,2),”/”,)&”/”&SUBSTITUTE(LEFT(C3,2),”/”,)&”/”&RIGHT(C3,4))