I am trying to make a cell that if it is past the date in another cell (K2) then it will display the word "EXPIRED." BUT will display nothing if it has not reached that date or no date was entered. I'm having trouble with nested IF AND statements. Here is what I have:
=IF(AND(K2<DATE, K2<>""),EXPIRED,"")
The date in K2 is in X/X/X format. I'm stumped and rather inexperienced in Excel. Thanks!
Bookmarks