In my downloaded Excel sheet, the date value is in MM/DD/CCYY format but my Laptop date format is in DD/MM/CCYY. So the value that has come as January 10th is read as Oct 1st. How can I read the date as it was intended ?
Also DATEVALUE function is expecting the Date in my Laptop Date format ( like DD/MM/CCYY ) so it throws an error ( #VALUE! ) when a date has come as 01/19/2021.