View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default date comparison help

A tough one. Is startDates declared as a number, or date variable?
Are the dates in the column Excel-readable dates (a number representing
the elapsed days since 1/1/1900, then formatted as a date)? If the
cells are text instead of numbers and startDates is a string variable,
that would explain why the = sign works but not the = or <=.