Excel

  • Excel,  Programming,  Scripts

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