|
|
|
|
|
|
by dmurray
437 days ago
|
|
|
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. |
|
|
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.