EXPIRY Warning

[dave6726]

Been stuck on this one for a while.

Col A = Due Date
Col B = Closed Date

Require in Col C: - If Due date is reached/passed (Overdue) for this I am using the formula =IF(A1<=TODAY(),"OVERDUE"," ")

However, I wish to override this if Col B contains a date (or any data in the cell)

To sum up, I am looking for a formula that will check if a Due Date has been reached/passed to give a visual warning. But if there is a Closed Date (or any other data) in Col B I do not need the Over Due warning. I appreciate that I could delete the date out of Col A, but require to keep this for future reference.

 

[wideboydixon]

=if(and(a1<=today(),b1=""),"overdue","")

wbd

 

[dave6726]

=if(and(a1<=today(),b1=""),"overdue","")

wbd

Thanks wbd - so easy when you look at it. Been going through all combinations. Much appreciated. Thank you