Are you importing from that spreadsheet? Dates need to be stored YYYYMMDD in ACF 5. Also, when you are sorting by date they need to be in a similar format, with year first, then month, then day. If the stored dates are in any other order then they will not sort properly.