Date formats in excel
Just for my memory, Just in USA the date format is mm/dd/yyyy, the rest of the world uses dd/mm/yyyy. Anyway… I have excels where I have both formats inherited from links, so I cannot change the source data. The solution: =IF(ISNUMBER(Q202);Q202;DATE(RIGHT(Q202;4);LEFT(Q202;FIND(“/”;Q202)-1);MID(Q202;FIND( “/”;Q202 )+1;2)))