What date do you think of with when you see the following date format:
If you are in the United States, you are probably thinking “does not compute”.
That day format (DD/MM/YYYY) is the one used by my Costa Rican banks and it is the one that makes most sense to me (going from smaller units, days, to the largest unit, years). When I feed the bank statements to my financing software, it chokes and labels everything opposite to what I want to in terms of months and dates. I thought I could easily fix this within Excel, but it was not as straightforward as I thought.