I have a table with dates:
A 3 5/05/2020 4 5/05/2020
and the formula in column B is: =IF(A4<>A3,"true","false")
Since dates are the same I expect to get a FALSE, but I am getting TRUE I have four different tables, and this works as expected in three of them, but does not work for the 4th. Not sure what to look into, checked formatting.
Edit: If formatted as General it shows:
Tried this with other working tables and they have: 43986
How would I format them to be the same? I tried Decrease Decimal option, but it rounds 6/05/2020 to be the same as 5/05/2020