Strange Condition on Date Value
Hi all
Am using Excel 2010 Macro
I had this condition which strangely holds TRUE for these values below:
CONDITION:
ElseIf Range("F" & z).Value Range("Q3").Value Then
VALUES
Range("F" & z).Value = 06-Jan-2015
Range("Q3").Value = 28-Feb-2015
This condition keep holding TRUE for the values. Is it not recognizing them as date values? If so, how do I force the condition to recognize them as date and thereby hold FALSE as expected.
|