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