I received an Excel file from a client that has two columns with dates xx/xx/xxxx. I need to sort the sheet by the first date column from newest full date (i.e., 10/01/2001 would come before 1/02/2001). I usually don’t have a problem with this butthis file keeps sorting based on the month only. Help!!
