As far as I can see, the formula you posted appears to already do what you
are asking for. Perhaps if you describe what you want for each possible X4,
Y4 combination, that might helps us to be able to answer your question.

--
Rick (MVP - Excel)


"Danny Boy" wrote in message
...
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")