
Fix the dates that will not sort
Dates that look right but sort wrong, and the quick way to turn them into real dates.

October 8, 2026 · 7 min
First names in one column, last names in the next, without retyping.
Free
A free letter every Sunday: one spreadsheet challenge with three hints, and last week’s worked in full.
“The one email I open the day it lands.”

Dates that look right but sort wrong, and the quick way to turn them into real dates.
59
Colour a row red when its date has passed, and only then.