IF statements and due dates

Hi all,

Needing a bit of help with this IF statmenet, if possible. I have a spreadsheet that calculates due dates for letters, i'm using this currently to calculate 5 working days from the date entered into AC2, if AC2 isn't blank.

=IF(AC2="","",WORKDAY(AC2,Data!$H$6,Data!$G$6:$G$14))

The trouble is I now only need the due date to appear if the letter hasn't already been sent within the 5 working days. The sent date is manually entered into AF2

So "if AC2 is not blank and the date in AF2 is not before AD2 calculate 5 working days from AC2"

AC2 = date query raised
AD2 = date our reply due (5 working days)
AF2 = date our reply is sent

It only needs one extra condition to check the letter hasn't already been sent but I'm having trouble writting it. Any help would be really appreciated - I'm already using three conditional formats to implement a red, amber, green system to keep track of the due dates if that makes any difference.

Thanks in advance!
Jess

Ah sorry, I've just realised I'm asking a ridiculous question - I'm putting this formula into AD2, so it's creating a circular reference.

I've tried the following - but the date i'm getting is 05/01/1990. Is there any other way?

=IF(AND(AC2="",AF2<WORKDAY(AC2,Data!$H$6,Data!$G$6:$G$14)),"",WORKDAY(AC2,Data!$H$6,Data!$G$6:$G$14))

Thanks for your help!

If you want a due date to appear IF no letter has been sent, ORa letter has been sent AND it was late, then you want this formula in AD2:

=IF(OR(AC2="",AND(AF2<>"",AF2<=WORKDAY(AC2,$H$6))),"",WORKDAY(AC2,$H$6))

That's perfect! Thank you for your help