Comment on Excel having a stab at dates
DomeGuy@lemmy.world 1 day ago
If you think that’s bad, look at what “1” means.
(And, honestly, at least windows’ “last big calendar change” and excel’s “start of the century when we wrote it” are reasonable points. The unix “let’s make it recent so we can fit an absurdly small unit as an integer!” Epoch is just… Weird.)
bleistift2@sopuli.xyz 1 day ago
This meme wouldn’t exist had they done that. But they chose the zeroeth of January for Excel.
radix@lemmy.world 1 day ago
Yep. “1” is 12:00am on 1-Jan-1900
Numbers less than zero just give a weird error. Between zero and less than one give a nonsense date-formatted non-date.