ISBLANK will not work if the OP's dates and/or his "empty cells" are the
result of a formula. For example, on an empty worksheet, put this formula in
A1...

=IF(A2="","","A2 is not empty")

and put this formula in B1...

=ISBLANK(A1)

it displays FALSE because the cell is not blank... it has a formula in it.

--
Rick (MVP - Excel)


"Chris" wrote in message
...
Try this:

=IF(OR(ISBLANK(X4),ISBLANK(Y4)),"",IF(COUNT(X4,Y4) =2,IF(TODAY()Y4,"Yes",""),"No")
)

"Danny Boy" wrote:

I'd like to modify this formula so that the NO Flag appears if a date is
missing in BOTH X4 and Y4. The current formula generates the NO flag, if
a
date is missing in either X4 or Y4. Any suggestions?

=IF(COUNT(X4,Y4)=2,IF(TODAY()Y4,"Yes",""),"No")