To Calculate the date

[YusufAkhtar]

Hi,

I have 24 different sub-Processes and all has different deadlines, for e.g. Sub-Process A needs to be completed in 24 hours from the received date. Sub-Process B needs to be completed in 10 Business days from the received date.

If from the drop down a sub-process is selected and received date is enter, the last working day should be automatically calculated. I tried using IF formula but more then 7 IF excel doesn't allow.

I tried using IF(OR) and IF formula - but it is not working

Below is the table where the second column are the example of days I have to complete the received work

Any help will be highly appreciated

Sub-Process A	10
Sub-Process B	10
Sub-Process C	5
Sub-Process D	5
Sub-Process E	10
Sub-Process F	1
Sub-Process G	5
Sub-Process H	5
Sub-Process I	10
Sub-Process J	2
Sub-Process K	1
Sub-Process L	30
Sub-Process M	30
Sub-Process N	2
Sub-Process O	2
Sub-Process P	2
Sub-Process Q	1
Sub-Process R	1

<tbody>
</tbody>

 

[steve the fish]

Hi. What are your business days?

 

[YusufAkhtar]

5 business days in a week. (Monday to Friday).

 

[steve the fish]

Table in A1:B18. Place your date in D1 and eg Sub-Process A in D2:

=WORKDAY(D1,VLOOKUP(D2,A:B,2,0))

 

[YusufAkhtar]

Great! Thank you so much for your help! Life is easier now