Fixed: Excel date format mix up issue

Date's got formatted in multiple type with "/" and "-".
This will make it difficult to sort and filter in excel.

Below dates got mixed up with but showing in  MM/DD/YYYY and MM-DD-YYYY format.

Fixed using below formula

=TEXT(DATE(RIGHT(TEXT(B2,"dd/mm/yyyy"),4),LEFT(TEXT(B2,"dd/mm/yyyy"),2),MID(TEXT(B2,"dd/mm/yyyy"),4,2)),"mm/dd/yyyy")

Now it will all show in same format.