Bob,
Good point (and carelessness on my part in my response). I MUST(!)
use the DATE function in future (write out 100 times).

"Bob Phillips" wrote:

Probably because Toppers uses UK style dates, you use US. Which is why you
should never use ambiguous date strings like that, see my earlier response
on how to overcome it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Erika" wrote in message
...
I entered =IF(B65DATEVALUE("15/9/06"),"true","") and got a Value error

"Toppers" wrote:

TRY:

=IF(B1DATEVALUE("15/9/06"),"true","")

"Erika" wrote:

I am trying to build a If statement using dates, I am getting all True
the
forumla I have built is =IF(B659/15/06,"true","") B65=9/1/06

What am I doing wrong?