Why [simple addition] 11/12/17+120 = 120 ?

[abi]

using formula: = (a1)+(b1). ?

[dmcranch]

If you are doing integer math, then the answer (120.054) would round to 120. How many digits of resolution are you using?

[librebel]

Hello @abi,

Apparently the value “11/12/17” in your cell A1 was not recognized as a Date in your locale.

– Try inputting your date as “11-12-17”

– Try setting the NumberFormat of cell A1 to a Date format “DD/MM/YY”

Then the outcome of A1 + B1 should be (date) “10-04-18”.