Calculate Future Dates with Weekend and Holiday Restraints

[QBERT]

Column A: Date that work is picked up (Example; Feb 4, 2016)

Column B: The number of Business days required to complete the job (Example; 3 days)

Column C: I need a formula to calculate the due Date


Here are the restraints:

1. I want generate a formula that takes column A and then adds one business day, excluding weekends and holidays, which is the start day for the 3 business days requires

2. In my example above if work was picked up on Thursday Feb 4 (Column A), then Friday Feb 5 is the first working day of three (Column B) and the due date (Column C) would show Tuesday Feb 9, 2016.


I am familiar with the network days function and how to exclude a predetermined list of dates, but am having trouble with this formula. Thanks.

Q

 

[jtakw]

Hi,

I think use WORKDAY rather than NETWORKDAYS:

Excel 2010
	A	B	C	D	E
1	Job Date	Days Required	Due Date		Holidays
2	2/10/2016	10	2/24/2016		1/1/2016
3					7/4/2016
4					12/25/2016
Sheet1

Cell Formulas
Range	Formula
C2	=(WORKDAY(A2,B2,E2:E4))

 

[QBERT]

Thank you!. Worked perfectly.

Q

 

[jtakw]

Thank you!. Worked perfectly.

Q

You're welcome.