Exclude holidays but include weekends

[roadtoexcel]

Hi All,

I need to create a formula that removes holidays from the equation, but does not exclude weekends. All of the workday.intl options want to remove at least 1 day a week for the weekend. I need a formula that would tell me what 40 days is before a certain date, but need an extra day in there if there is a holiday present.

Thanks!

 

[MARK858]

All of the workday.intl options want to remove at least 1 day a week for the weekend

No they don't, the below doesn't include any weekends
=WORKDAY.INTL(A1,-40,"0000000", RangeHostingYourHolidayDates)

 

[MARK858]

Sorry should have added your minus 40 stipulation.... formula in previous post edited, A1 is your start date.

 

[roadtoexcel]

Awesome - that worked. Thanks!

 

[MARK858]

You're welcome, just so that you know you use a 1 rather than a 0 to define weekend days using that syntax, starting from Monday so
=WORKDAY.INTL(A1,-40,"1100000", RangeHostingYourHolidayDates) would treat Monday and Tuesday as weekend days.