Hi!

Here's the formula: (assuming that the dates are true Excel dates and not
just TEXT strings)

=IF(COUNT(G5:I5)=3,"checkmark","x")

Why not use the "x" as the checkmark and maybe a dash (-) to indicate the
condition has not been met:

=IF(COUNT(G5:I5)=3,"X","-")

Biff

"Rosco" <rosco111NOCAPS@charterNOCAPS.net> wrote in message
news:Xns97BCE8371AF07rosco111@69.28.186.121...
>I can't seem to figure this one out. I am trying to make either a
> checkmark, someones intials or a check box (reall doesn't matter which
> but check mark would be best) appear in a cell when three other cells
> in that same form contain data. The cells that need to be searched
> woutl only contain dates but the accutall date entered is irrelevant to
> the check box so I would assume that it only needs to search for
> generic data. The dates are entered as 05/01/06. Using online help I
> have been trying and trying with "=IF(ISNUMBER(SEARCH("/",AND
> (G5,H5,I5))),"checkmark","x")
> With that formula i always get the false indicator of x