Convert YYYYMMDD strings to Excel dates using DATE and text functions for reliable sorting and formatting.