I'm trying to compare dates within an =AND() function but having trouble.
I can get =IF() to work but not =AND().
E.g. Cell A1 = 6/15/2009
I can do =if(A1<6/30/2009,GOOD,BAD)
WOrks fine.
When I do =IF(AND(A1<6/30/2009,TRUE),GOOD,BAD)
it doesn't give the right answer. Is there something about formatting dates
within AND() that makes it fail, when it works within an IF function?