Thanks so much for your valuable contribution. I have just checked with one of my scenario to calculate due with your formulae and result seems to be incorrect. Below is the example I used,
Start Date = 12/6/2017 | No. of days = 3 | Holidays = 12/6,12/7,12/9,12/10
Due Date should be = 12/13... Below is the manual calculation for the result. Can you pls help...
12/6 - Holiday
12/7 - Holiday
12/8 - Day 0
12/9 - Holiday
12/10 - Holiday
12/11 - Day 1
12/12 - Day 2
12/13 - Day 3
Why 12/8 is Day 0? Shouldn't it be Day 1?
If you don't want to count the first day maybe...
=WORKDAY.INTL(A2,B2+1,"0000000",Holidays)
M.
Thanks so much. When I apply this formulae I am getting #value error. can you pls help
A | B | C | D | E | |
1 | StartDate | Days | Result | Holidays | |
2 | 12/06/2017 | 3 | 12/13/2017 | 12/06/2017 | |
3 | 12/07/2017 | ||||
4 | 12/09/2017 | ||||
5 | 12/10/2017 | ||||
6 |