Dates are same but result is coming False

[Shabbo]

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.

 

[AliGW]

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:

=DATEVALUE(B2)

so this formula:

=A2=DATEVALUE(B2)

will return TRUE.

 

[pecoflyer]

@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

 

[AliGW]

Ali's nickname might be " EagleEye Ali "

With date issues, it's the first thing I look for: 90% of date issues are related to this issue.

 

[Marc L]

Or just using ISNUMBER as TRUE is an Excel Date …​

​