| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK")
=IF(E11="","",IF((E11-TODAY()<0), "EXPIRED", "OK"))
-- Gary''s Student - gsnu200727 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| "NOW" or "TODAY" date function | Excel Worksheet Functions | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
