Getting exact end date excluding sundays and holidays.

[rehanemis]

Hi,

Here is little problem. I would like to get end date using "workday" function. Actually I want the end results as.

Example:

Start Date: 11/15/2017
working days: 12
Holidays: 0
End Date should be: 11/28/2017

I want to count the starting date also like if working day is= 1 then end date should be 11/15/2017.

Any idea?

 

[Scott Huish]

Excel 2010
	A	B	C	D
1	Starting Date	Working Days	Holidays:	End Date:
2	11/15/2017	12	0	11/28/2017
Sheet1

Cell Formulas
Range	Formula
D2	=WORKDAY.INTL(A2-1,B2+C2,11)

You could eliminate the need for you Holidays column if you made a list of your holidays and used that feature of the WORKDAY.INTL function, so if your holidays were in Column H, you could do this instead:
=WORKDAY.INTL(A2-1,B2,11,$H:$H)

Excel 2010
	A	B	C	D	E	F	G	H
1	Starting Date	Working Days	End Date:					11/16/2017
2	11/15/2017	12	11/29/2017
Sheet1

Cell Formulas
Range	Formula
C2	=WORKDAY.INTL(A2-1,B2,11,$H:$H)