I am trying to create a data entry spreadsheet that will track
responses to surveys that we do....whether responses are received on
time, whether such were received late, whether the due date has passed
and such is overdue, or whether similarly nothing has been received
yet but the due date has yet to come.

Is there any way in the attached spreadsheet to make the blank cell
(i.e. C4) representing lack of responses, produce an "overdue" in D4?

Also for the blank cell in C5 where the response isn't yet due, is
there some sort of DATE function that might be nested in there to
produce a "not yet due" result?

This is way beyond my =sum limit of expertise.

Would appreciate any help someone could provide. Such can be sent to
me directly at

Thanks in advance!!

Scott Phillips