Forum Discussion
Solved
If deadline date has passed then enter Overdue, but if the deadline date is blank then leave blank
Hi everyone, I have a set of deadlines in column C, and a "Deadline Ticker" in column D. I have two sets of formulas: =IF(C:C<TODAY(),"OVERDUE"," ") - so if the deadline date in column C ha...
HansVogelaar Thank you for your reply - it worked!
I am an excel novice, is there any particular reason why one would use
C:C <> " "
rather than
C:C= " "
It's actually C:C<>"" (without a space between the quotes).
The condition AND(C:C<>"",C:C<TODAY()) says that the cell in column C must not be equal to the empty string "" (i.e. it is filled) and before the current date.
It would have been possible to use C:C="", but that would make the formula longer:
=IF(C:C="", "", IF(C:C<TODAY(), "OVERDUE", ""))
