IF Statement

Hi Wendy

Thanks for helping with this

New to IF statements so please bear with me.

=IF(C4="","",IF(B4>=C4,"Yes",IF(AND(B4<TODAY(),B4=""),"Overdue","No")))

where B4 is the Due date and C4 is the Completion date.

in my if statement if the Due date (Cell B) would need to be before the completion date (Cell C) to mark it as YES so the first part of the statement is working correctly for me

however, the second part where the due date has passed than today and the completion date hasn't been entered then mark this as overdue. I am not able to get this with the equation below as this is returning blank

IF(AND(B4<TODAY(),B4=""),"Overdue","No")))

I can see the issue is around the due date as my due date (cell B4) is auto populated with a date and will never be blank

For example - if the Due date is 21 Jul 2017 (cell B4) and Completion date (cell C4) is (blank) - this is returning blank cell with the above equation however I am looking for this to return OVERDUE -

Is there a solution as to how this can be set to return OVERDUE?

Hope that helps to understand my issue


Many Thanks
Kay