A very good point you’ve made there :)
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.
> “1/2” concatenates with “1”
…and thought you’d spotted that and was saying others had disagreed with the concatenation way of handling + operators with strings.
https://www.lenovo.com/us/en/glossary/concatenate/#:~:text=C...
That doesn't make those two strings equal, however.
You can try string concatenation in 3 differently languages using the links below:
https://www.w3schools.com/python/python_strings_concatenate....
https://go.dev/play/p/Q5VPF2ANk7Y
https://www.w3schools.com/jsref/jsref_concat_string.asp
Edit: who said anything about making both side of the operator equal? That’s not how operators work.