Discussion on:

Message 14 of 15
0 Votes
+ -
Figured out how to exclude weekends as well
When making your list for Holidays simply follow that with all the weekend dates for the year. Then make sure the holiday dates and weekend dates are selected together. Use the formula provided in this example and it works! Please remember you might have to add the add in. Go to the help search and type in NETWORKDAYS where it will provide direction as to how to get the add in and other helpful hints. Really glad I found this on the web, saved me a ton of time!!!!!! THANK YOU!
Posted by sciencegal
9th Feb 2011