View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] kriskapella@gmail.com is offline
external usenet poster
 
Posts: 8
Default 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.