using formula: = (a1)+(b1). ?
If you are doing integer math, then the answer (120.054) would round to 120. How many digits of resolution are you using?
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”.