ExcelBanter - Multiple Holidays using Networkdays

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Multiple Holidays using Networkdays (https://www.excelbanter.com/excel-discussion-misc-queries/450885-multiple-holidays-using-networkdays.html)

robsterbuk

Multiple Holidays using Networkdays

Hi, I have a spreadsheet which calculates the working days between two dates - easy!

We now want the user to be able to type in multiple holidays into a separate table, including ranges of holiday -e.g 04/05/2015-10/05/2015 is this possible?

Thanks,

All times are GMT +1. The time now is 08:28 AM.