The running joke about Excel and "is this a date"

mikeymikec

Lifer
May 19, 2011
21,543
16,781
136
I was updating my transactions spreadsheet and had intended to type 29/1 (for the 29th of Jan, UK here we don't do wonky dates), but I typed 29/2 instead, at which point LibreOffice Calc seemingly treated it as text leading me to think wtf libreoffice? I then typed 29/1 into the same box and it decided that it should in fact be dealt with as a date, leading to a double wtf. Then I realised the software's wisdom :) (2026 is not a leap year)