IF function not working.

Hey

I have a bit of a problem with my If Function.

I have two dates in two seperate colums. in the format dd/mm/yyyy. The columns are W and Q.

I have input an If Function along the lines of =If (W2=Q2), "", "Re-allocate"

The problem i'm having is that when the two dates match in both columns the formula is still returning "Re-allocate".

I think the problem might lie with the formatting of column Q. The date shown is the date retrieved from a vlookup function, from another sheet, that includes a time of day as well such as 00:00:00. The v lookup is only returning the date however.

Any thoughts as to why this is not matching? or Excel not recognising the two as the same date?

Thanks