View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo Jo is offline
external usenet poster
 
Posts: 113
Default 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?