Workday Calculations to Account for Non-Workday Start Days

[reberryjr]

I'm trying to build something to calculate a due date, but am running into some issues with calculating workdays where the start date is a non-workday.

Scenario
Item is received on 7/29/18. The deadline should be 2 working days. This formula pushes the due date to 7/31, but I need for it to say 8/1/18.
=WORKDAY(D11,2,Variables!D$2:D$11)

I started down the path of an IF statement, but I'm not sure how I can write to evaluate the difference between the start date being a Saturday, Sunday or holiday.
=IF(WORKDAY(D11,0),WORKDAY(D11,2,Variables!D$2:D$11))

FYI...the range on the Variables tab is a list of holidays.

I'd like to avoid building another helper column if possible, as there are downstream spreadsheets that leverage the current layout. I'm not sure if I need to try something in VBA instead of a direct formula.

Thoughts?

 

[Dave Patton]

Excel 2010
	A	B	C
1	Received	Days	Deadline
2	Sun Jul 29, 2018	2	Wed Aug 01, 2018
3	Sun Jul 29, 2018	3	Wed Aug 01, 2018
4	Fri Jul 27, 2018	3	Wed Aug 01, 2018
5
1a

Cell Formulas
Range	Formula
C2	=WORKDAY(A2,B2+(WEEKDAY(A2,2)>5))
C3	=WORKDAY(A3,B3)
C4	=WORKDAY(A4,B4)

 

[steve the fish]

See if this works:

=WORKDAY(D11-1,3,holidays)

 

[arthurbr]

Perhaps =IF(WORKDAY(A1-1,1)=A1,WORKDAY(A1,2),WORKDAY(WORKDAY(A1,1),2))

Add holiday ranges as needed

 

[Dave Patton]

Excel 2010
	A	B	C
2	Sun Jul 29, 2018	2	Wed Aug 01, 2018
3	Mon Jul 30, 2018	2	Thu Aug 02, 2018
4
5	With Jul 30 as a holiday
1a

Cell Formulas
Range	Formula
C2	=WORKDAY(A2,B2+(WEEKDAY(A2,2)>5))
C3	=WORKDAY(A3,B3+(WEEKDAY(A3,2)>5),Hol)+COUNTIF(Hol,A3)

Named Ranges
Name	Refers To	Cells
Hol	='1a'!$E$2