I've tried =if(and(cell= "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
result is not right. Any thoughts?

Try

=IF(AND(A1=DATE(2005,1,1),A1<DATE(2005,2,1)),"yes ","no")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"JHL" wrote in message
...
I've tried =if(and(cell= "1-1-2005",cell<"2/01/2005"),"yes",
"no") and the
result is not right. Any thoughts?

Embed the Date function to convert from dates people understand to what Excel
uses: =if(and(cell=date(2005,1,1),cell<date(2005,2,1)), "yes","no")
--Bruce

"JHL" wrote:

I've tried =if(and(cell= "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
result is not right. Any thoughts?

One way:

=IF(AND(cell=DATE(2005,1,1),cell<DATE(2005,2,1)), "yes","no")

In article ,
JHL wrote:

I've tried =if(and(cell= "1-1-2005",cell<"2/01/2005"),"yes", "no") and the
result is not right. Any thoughts?

=AND((A1=--"2005-01-01")),(A1<--"2005-02-01)"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"JHL" wrote in message
...
I've tried =if(and(cell= "1-1-2005",cell<"2/01/2005"),"yes", "no") and
the
result is not right. Any thoughts?