What are you trying to show here?
Excel 2016 (Windows) 32 bit
A B C 5 4 06/02/2018 06/02/2018
Sheet: l
You have to bear in mind that there are two different conventions with dates: in the US, mm/dd/yyyy is correct, whereas here in the UK and pretty much everywhere else it's dd/mm/yyyy.
Bookmarks