Exclude Holidays only, not workdays

[craigg3]

I know I can use the Workday function to get the end date that excludes weekends and optional Holidays.....but is there a function where I can list a start date, number of days and also exclude Holidays, but not exclude weekends and get the end date?

 

[Dave Patton]

Date and Time.xlsm
	A	B	C
1	Oct 31, 2020	30	Dec 1, 2020
2
17d

Cell Formulas
Range	Formula
C1	C1	=WORKDAY.INTL(A1,B1,"0000000",HolidayList)

Named Ranges
Name	Refers To	Cells
HolidayList	='17d'!$K$2:$K$26	C1

 

[craigg3]

Thanks Dave, I will give that a try.