HELP WITH NESTED STATEMENTS

[dougie]

HELP.....

I have a query that requires FOUR possible answers depending on the data contained within a cell.


I have FOUR columns. The STATUS column being where i want the formula to be.

DATE ACCEPTED, DATE AUTHORISED, DATE RECEIVED, STATUS.

What I am trying to achieve is:

1: If DATE AUTHORISED cell is NULL after five days from DATE ACCEPTED cell, then give me a message to say "Chase Authorising Officer" once date entered into DATE AUTHORISED cell say "AUTHORISED"

Then,

2: Once DATE AUTHORISED has been entered and DATE RECEIVED cell is NULL after 5 days give a message to say "CHASE ME" once date entered into DATE RECEIVED cell say "COMPLETE".

I dont know if it can be done, but I will be extremely gratefull for the time giving in solving this nightmare for me.

Many thanks in anticipation.

Dougie
[/img][/url][/list][/code]