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

Leave a Reply

Your email address will not be published. Required fields are marked *