Covert date format in ms excel 2013 from MM-DD-YYYY to DD-MM-YYYY

Change date format in ms excel 2013 form MM-DD-YYYY to DD-MM-YYYY

 

 

=DATE(VALUE(RIGHT(A2,4)),VALUE(LEFT(A2,2)),VALUE(MID(A2,4,2)))

where the MM-DD-YYYY string is in cell A2.

Add Comment