Solved How to add working days to a drop down?

July 20, 2016 at 09:39:49
Specs: Windows 7
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.


See More: How to add working days to a drop down?

Report •


#1
July 20, 2016 at 09:59:44
✔ Best Answer
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


Report •

#2
July 20, 2016 at 10:34:24
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.


Report •

#3
July 20, 2016 at 10:56:44
Oh wow thank you I'll give this a try!

Report •

Related Solutions

#4
July 20, 2016 at 11:00:45
Brill thank you so much - works perfect!

Report •


Ask Question