Formula Help Needed - Tracking Responses.xls (0/1)
 

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

Formula Help Needed - Tracking Responses.xls (0/1)
 

Scott, attachments cannot be posted here.

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?

put this formula in D4:
=IF(C4="","Overdue","")

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?

When Date due is in B5, put this in C5:
=IF(B5TODAY(),"not yet due","")

Without seeing your data, this is a best guess.
Mike F
"Scott" wrote in message
...
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