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