SOLVED

If deadline date has passed then enter Overdue, but if the deadline date is blank then leave blank

New Contributor

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

@DaniSingam 

For example:

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

@Hans Vogelaar 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= " "

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