Date - greater than and less than

J

John H.

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.
 
B

Bob Phillips

=IF(A1<--"2006-02-01",1,0).


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top