Question: how to convert m/d/yyyy to dd/mm/yyyy in excel?
Answer: date-text = TEXT([@[date]],"mmm/ddd/yyyy") - to fix date format to mm/dd/yyyy mm =LEFT([@[date-text]],2) dd =MID([@[date-text]],4,2) yyyy=RIGHT([@[date-text]],4) concat(dd,mm,yyyy) = =CONCAT([@dd],"/",[@mm],"/",[@yyyy]) to get mm/dd/yyyy for mat.