CODEWITHSUNDEEP
excelexcel-formuladate-comparison
ComplexData
ComplexData

Reputation: 1093

Why does the below date comparison in Excel return false?

The two columns in Excel contain custom date in a format of d-mmm. The date 19-Jul in column D11 is for the month 2021. The date 3-Jan in column H8 is for the month 2022. I am using the below formula to compare the two dates, and the result should be true, but somehow this formula returns false.

=IF(H$8>=$D11),"True","False")

Upvotes: 0

Views: 2143

Answers (1)

EDS
EDS

Reputation: 2195

One way to prove to yourself that the problem is likely the format of the "dates" themselves is to flip the formula: If =IF($D11>H$8,"True","False") (omitted first parenthesis as that seems to be an input error) also returns "False", then you are not comparing dates.

You can fix this issue a million different ways depending on what the cell is actually being stored as; I'm sure you will be able to quickly find something.

Upvotes: 0

Related Questions