I'm trying to modify the formula below (I have written the formula in cell
AA4) a bit, but am having trouble. The formula works as it is currently,
however, I want to add one more piece that I can't seem to get.

I'd like the NO flag (in cell AA4) to appear if cell X4 AND cell Y4 are
blank. If cell X4 and cell Y4 have dates in them, and today is greater than
the date in cell Y4, than I want the flag in cell AA4 to say YES.

Any attempt to add in the formula infomation regarding cell X4 seems to
result in errors, or FALSE outcomes. Below is the formula as I originally
wrote in (without the needed addition of the cell X4 information described
above):

=IF(Y4="","NO",IF(TODAY()EDATE(Y4,0),"Yes",""))

Thanks much,

Dan