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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sub-Process A[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Sub-Process B[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Sub-Process C[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Sub-Process D[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Sub-Process E[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Sub-Process F[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Sub-Process G[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Sub-Process H[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Sub-Process I[/TD]
[TD]10
[/TD]
[/TR]
[TR]
[TD]Sub-Process J[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sub-Process K[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Sub-Process L[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]Sub-Process M[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]Sub-Process N[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sub-Process O[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sub-Process P[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sub-Process Q[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Sub-Process R[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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