D
Danny Boy
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")
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")