I would like to enter dates into two different cells. If both of these two
sells have dates in then a third cell will display the word "no"

Hi
=IF(COUNT(A1:A2)=2,"no","yes")

--
Regards
Frank Kabel
Frankfurt, Germany


Teresa Warne wrote:
I would like to enter dates into two different cells. If both of
these two sells have dates in then a third cell will display the word
"no"

Hi Teresa

not sure if you want "yes" or "no" if both cells have dates .. assuming you
want "yes" (as per the subject line) then
=IF(OR(A1="",B1=""),"no","yes")
this means if either of A1 or B1 is blank then display NO, when they both
have something in them then display YES
or
=IF(AND(A1<"",B1<""),"yes","no")
this one says when A1 has something in it, and B1 has something in it then
display YES otherwise display NO.

Note, this doesn't check if the entries are actually DATES or not. If you
need this type of check, please post back with the possible date range that
you are expecting.

Regards
JulieD


"Teresa Warne" <Teresa wrote in message
...
I would like to enter dates into two different cells. If both of these two
sells have dates in then a third cell will display the word "no"