YusufAkhtar
New Member
- Joined
- May 31, 2018
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
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
<tbody>
</tbody>
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>