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