Date comparisons within AND() functions

S

Sambonator

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?
 
B

Bernie Deitrick

=IF(A1<"6/30/2009","GOOD","BAD")
=IF(AND(A1<"6/30/2009",TRUE),"GOOD","BAD")
both worked for me.

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing dates from VLOOKUP functions not working right 2
How do I write an If(And( function using dates as my logical test? 4
IF 2
IF 4
Slope??? help please!!! 1
Count if between date parameters 4
If statements?? 2
Counting Occurrence of a Value within Cells 1

Top