1/1/2004 is equal to 1 divided by 1 then divided by 2004, which gives a
number equivalent to a date and time of 43.11 seconds after midnight on 0th
Jan 1900.
That's the date and time with with you are comparing. That's why the other
folk have told you how to put the correct date into your formula.
--
David Biddulph

"Pam D in Indy" <Pam D in wrote in message
...
I'm not getting good values when I use dates in conditional or AND
formulas.
Example: =if(A11/1/2004),1,0)
Example: =IF(AND(A11/1/2004,A1<1/1/2007),1,0)

Everything comes back either true or false, but not true to case.