Add workdays to start date, inluding saturdays and holidays

Hello everybody,

I am working with Excel 2007 and Wjndows Vista
I need to calculate the end date, having the start date and workdays. I also have a holidays range (SHEET1).
Before the second of October 2016, Saturday is a working day, after this date, Saturday will be considered as a not working day.

I used the following functions: weekday, workday ….., but I do not get the correct answer
I'm struggling with, but I am not be able to sort it out. I am not an expert with Excel, I have an intermediate level
I attach the file
Any help would be appreciated. Thanks in advance

Excel 2010 with Power Query Add-In.
Compatible with Office 2013/2016 Pro Plus.
For incredibly advanced users.
http://www.mediafire.com/download/u4ho68tioisa84y/12_30_15.xlsx

Hello,
Thanks so much. Your answer is impressive for beginners as me.
Now, my question is: Does this procedure work before 07/24/2016? For example:
Start date: 0((02/2010
Workdays:30
Saturday is a working day
May I know the logic of your proposal?
Thanks again for your kind attention

Cross post without links

http://www.msofficeforums.com/excel/29304-add-workdays-start-date-inluding-saturdays-holidays.html

Read this to understand why you should add links

Hello everybody,
Thanks for ypur reply.
I must to tell the forum experts that I have no intention of duplicating the work of the experts.
I only want to get the correct answer, not pick the best one.
I am so sorry for my mistake, I do not have experience using the forums.
From now, I will follow the suggestion of your link about the use of forums and the cross-post.
Please, accept my apologies. I am so sorry, it will not happen again.

My program works for all dates,
but for queries spanning years, the size of the Tables becomes unwieldy.
A switch to VBA, Solver and Defined Names would be called for,
but the complexity of the solution would stay the same.