I hope I can explain this right. In column F I have a drop down list for each cell within that column so users can pick the correct classification out of:

Minor (5 working days)

Moderate (10 working days)

Major (15 working days)

Severe (25 working days)In column G I want to add a formula that will automatically input the date the response is required by which is determined by which classification is picked.

The date the complaint/comment received is logged in column A.

Can anyone help with this please? Is there such a formula?

Thanks.

Try this nested IF formula: =IF(F1="Minor",WORKDAY(A1,5),IF(F1="Moderate",WORKDAY(A1,10),IF(F1=...etc.

P.S. You may want to use a Holiday list with the WORKDAY function.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

One more thing: If the list of classifications for the drop-downs are in a range of cells, e.g. K1:K4, you can reference those cells instead of hardcoding the text into the formula:

=IF(F1=K1,WORKDAY(A1,5),IF(F1=K2,WORKDAY(A1,10),IF(F1=...etc.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Oh wow thank you I'll give this a try!

Brill thank you so much - works perfect!

Ask Your Question

Weekly Poll