Thread: Strange Condition on Date Value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Strange Condition on Date Value
Hi Kris,

Am Wed, 4 Mar 2015 03:32:32 -0800 (PST) schrieb :

Range("F" & z).Value = 06-Jan-2015
Range("Q3").Value = 28-Feb-2015

are that true dates?
If not try it with datevalue:
If DateValue(Range("F" & z)) DateValue(Range("Q3"))

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
Reply With QuoteReply With Quote