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.

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"John H." <John wrote in message
...
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.