View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan L. Wagoner Alan L. Wagoner is offline
external usenet poster
 
Posts: 13
Default AND Headache (with dates)!

Greetings All,

I'm going crazy trying to figure out what's wrong.

In A1, I have the following:
01/30/2004

In B1, I have the following formula:
=And(A1< "02/01/2004")
which results in: TRUE (makes sense to me...)

In C1, I have the following formula:
=And(A1 "12/31/2003")
which results in: FALSE (huh?!?!)

In B2, I have the following:
=And(A1< 02/01/2004)
which results in FALSE (huh ?!?!)

In C2, I have the following:
=And(A1< 12/31/2003)
which results in TRUE (makes sense to me).

What is going on?

Thanks in advance!

--Alan