Comment on Excel having a stab at dates
DomeGuy@lemmy.world 5 weeks 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 5 weeks ago
This meme wouldn’t exist had they done that. But they chose the zeroeth of January for Excel.
radix@lemmy.world 5 weeks 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.