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))