That didn't seem to work Chris. The YES flag triggered per the formula below,
but not the NO flag (even if X4 and Y4 were blank).

What I am trying to do, is to have a formula that will trigger a "YES" flag
(in cell AA4) if today's date is greater than the date posted in cell Y4 (the
ending date of an identified class). Cells X4 is the start date of a class,
and cell Y4 is the end date.

If a student no shows for that class, I would remove both the start date
(X4) and the end date (Y4). Once BOTH the start and end dates are removed,
than the flag in AA4 should say "No" (signifying that a student did not
complete class).

If dates are present in cells X4 and Y4, but the date in cell Y4 has not yet
passed (the scheduled class has either not yet begun, or is in process), than
cell AA4 should remain blank.

Thanks for any help. Rick I hope that clarifies what I'm looking to do.

Dan

"Chris" wrote:

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")