SOLVED

New Contributor

# 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 has passed the cell in column D willl return "OVERDUE", if it has not passed, the cell in column D is left blank

But if there is no date in the cells in C, I dont want it to return anything in column D. So I came up with this formula:

=IF(C:C=""," ","") - So when there is no deadline in C, the cell in D will remain blank

I am having trouble bringing these two formulas together:

If deadline date has passed then enter "OVERDUE", but if the deadline date is blank then leave blank.

I have tried OR and ELSE but I think this is over my head.

Thank you

3 Replies
best response confirmed by DaniSingam (New Contributor)
Solution

# Re: If deadline date has passed then enter Overdue, but if the deadline date is blank then leave bla

For example:

=IF(AND(C:C<>"",C:C<TODAY()),"OVERDUE","")

# Re: If deadline date has passed then enter Overdue, but if the deadline date is blank then leave bla

I am an excel novice, is there any particular reason why one would use

C:C <> " "

rather than

C:C= " "

# Re: If deadline date has passed then enter Overdue, but if the deadline date is blank then leave bla

@DaniSingam

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", ""))