View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John H.
 
Posts: n/a
Default Date - greater than and less than

Hi.

I'm writing a function where I need to know if a date is earlier than or
later than a base date. I'm trying to use an IF function:
=IF(A1<2/1/06,1,0).

But for some reason it's not recognizing the dates - or something is wrong.

What's not right?

Thanks.