On Thu, 31 Jan 2008 19:59:56 GMT, "Conan Kelly"
wrote:

John in Wembley,

First, why are you using the Date() function? It appears that G13 is
already a data an all you are doing is adding days.

I would change the formula you posted to:

=IF(H13="Logged",G13+1,IF(H13="Acknowledged",G13+2 0))

Then, instead of adding 1 or 20, you might look into adding NETWORKDAYS() or
WORKDAY()

HTH,

Conan

Thanks for that, it was silly of me to be using the date function