• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dates are same but result is coming False


Dear Sir,

Reference to attached file Dates are same but result is coming False.

Can you please help me to understand why its coming false.


  • DATES.xlsx
    17.7 KB · Views: 5
A2 is a date, B2 is text that looks like a date. Set the cells' formatting to GENERAL and you'll see the difference.

You can use:


so this formula:


will return TRUE.
@Shabbo And FYI, without manual alignment text is left aligned in cell, numbers are right-aligned. At a glance you can see what is wrong (BTW Ali's nickname might be " EagleEye Ali " :))
So, avoid applying manual alignment before you are satisfied with you formulas