Counterpoint: What you say applies in daily life, not when querying an archive of any kind. Year-month-day is the natural sorting order if the question is “which file/folder/column in the spreadsheet is the one I need?” In which case you narrow it down to first the year, then the month, then the day.
I started using YYYY-MM-DD to name files and directories once I noticed that they then became automatically sorted chronologically when I sort the containing directory alphabetically by file name.
Counterpoint: What you say applies in daily life, not when querying an archive of any kind. Year-month-day is the natural sorting order if the question is “which file/folder/column in the spreadsheet is the one I need?” In which case you narrow it down to first the year, then the month, then the day.
I started using YYYY-MM-DD to name files and directories once I noticed that they then became automatically sorted chronologically when I sort the containing directory alphabetically by file name.