To match dd/mm/yyyy and mm/dd/yyyy column values in columns C (Date1) and N (Date2), I used these formulas in row 2: Meaning: Column: Formula: Explanation: Date1Text I =TEXT(C2,”dd/mm/yyyy”) Interpret date text of the original text no matter the Excel settings Date1Value J =DATE(RIGHT(I2,4),MID(I2,4,2),LEFT(I2,2)) Encode the date text to an actual date: dd#mm#yyyy format where # […]

via Convert a text value into a date in Excel. Learn Microsoft Excel | Five Minute Lessons — The Wiert Corner – irregular stream of stuff