News for hackers. Stuff that matters.
Re:Cursed Excel: "1/2"+1=45660 by dmurray on Monday April 07, 2025 @12:49PM (#43613422)
Why would you favour "date plus a day" rather than "number plus a number"?

I agree Excel has to guess, and in isolation guessing that "1/2" should be parsed a date is not a terrible choice, and that parsing the individual components separately is simpler and more predictable than using the full context that it's about to be added to a number. But evaluating to 1.5 would raise few eyebrows.

Re:Cursed Excel: "1/2"+1=45660 by hnlmorg on Monday April 07, 2025 @01:34PM (#43613919)
> Why would you favour "date plus a day" rather than "number plus a number"?

Date is a number though. It’s only when we print them in a human readable way that they become anything else.

Whereas 1/2 is an expression.