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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ignore blank cells when calculating date for If, Then function 2
Logical functions with dates and TODAY() 9
Conditional Format for a date 1 month before Expiration in Excel 2 2
Conditional formatting referencing date of expiration 5
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
EOMONTH, TODAY() and Conditional Formatting (Excel 2003) 1
If cell is blank automatically enter today's date in the same cell 21
conditional formatting for Column with Dates 2

Back
Top