how to add dates (including weekends) but excluding holidays

[ellysonkm]

Hello,

I am trying to write a formula that counts 60 days from each date listed in column A, INCLUDING weekends but EXCLUDING school holidays. I have put all the school holidays for the year in another column and made it a table.

I can't use Workday or Workday.intl because they omit weekends, and I haven't figured out how to make them just count all 7 days of the week. I have MS. Excel 365.

Please help.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=WORKDAY.INTL(A2,60,"0000000",Holidays)

change "Holidays" to the name of table.

 

[ellysonkm]

OMG! Thank you!! It works!

 

[Fluff]

You're welcome & thanks for the feedback.