find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK")
 

Someone clever helped me with the above formula to flag overdue dates in a
reminder spreadsheet. It works beautifully, except that I'd prefer "expired"
to appear only if there is a date in the adjacent cell. At the moment it's
referring to blank cells as well as those with an overdue date.

Can you add to the formula to allow for blank cells?

find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK")
 

=IF(E11="","",IF((E11-TODAY()<0), "EXPIRED", "OK"))

--
Gary''s Student - gsnu200727