.... which can, of course, be simplified to
=IF(AND(ISNUMBER(U5),ISNUMBER(V5),ISNUMBER(W5),She et2!H5="X"),TODAY(),"")
as you don't need the =TRUE in each case.

I wonder, however, whether the OP really wants TODAY() as the result, as the
answer will then change tomorrow. If he wants the value to freeze, he
probably needs a VBA solution.
--
David Biddulph

"FSt1" wrote in message
...
hi
use this one instead....
=IF(AND(ISNUMBER(U5)=TRUE,ISNUMBER(V5)=TRUE,ISNUMB ER(W5)=TRUE,Sheet2!H5="X"),TODAY(),"")

regards
FSt1
"FSt1" wrote:

hi
don't use this formula. i just did another test and it failed.
working.

regards
FSt1

"FSt1" wrote:

hi,
try this....
=IF(AND(CELL("format",U5)="D4",CELL("format",V5)=" D4",CELL("format",W5)="D4",Sheet2!H5="X"),TODAY(), "")

the format of =cell() may give you problems. per help on =Cell(), your
format = D1.
in a cell(off to the side) enter....=cell("format",U5). replace the
return
format in the above formula with the format that =cell() returned.

regards
FSt1
"armymatt" wrote:

I have dates in 3 seperate colums for 3 seperate tasks on Sheet 1. On
Sheet 2
with in the same file i have a colomn that has either nothing or an X
in it
when a specific task is complete.

the three date colomn's aU5, V5, W5.
the other column is H5 on the other sheet.

I want to create a formula that when all 4 variables are entered, it
puts
the date when all tasks were completed in cell T5 on sheet one.

what i have come up with so far is this:
=IF(AND(U5=dd-mmm-yy,AND(V5=dd-mmm-yy,AND(W5=dd-mmm-yy,AND('sheet2'!H5=X)))),"TODAY(dd-mmm-yy)",""


any help would be greatly appreciated