If Statements with Dates
=IF(B65DATE(2006,9,15),"true","")
or
=IF(B65--"2006-09-15","true","")
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Erika" wrote in message
...
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?
|