If statements

[John in Wembley]

Im using the following formula to set to date by which a complaint
need to be processed by our manger.

=IF(H13="Logged",DATE(YEAR(G13),MONTH(G13),DAY(G13)+1),IF(H13="Acknowledged",DATE(YEAR(G13),MONTH(G13),DAY(G13)+20)))

He has 1 day to responde to a logged complaint, 20 days onces its
being acknowledged to respond...
Now the boss says, he wants 20 working days.
Is it any way possible to include network days?
Ive tried but I think it cant be done.

So its 1 day for the manger to acknowledge a logged complaint, 20
working days to respond.

 

[Conan Kelly]

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+20))

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

HTH,

Conan

 

[John in Wembley]

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+20))

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