Exclude Weekends and Public holidays using one datefield

[#1]

Good day,

The question I asked earlier on was not so clear. Now I am simplifying it, I have a date field called LeaveDate and it contains Working days from Monday to Friday, Weekends and Holiday. So in my country if a holiday falls on a Sunday, then following day(i.e Monday) will be counted as a holiday. So in my attached spreadsheet, I have highlited the holidays and weekends in Yellow. So what I would like to exclude weekends and public holidays.

         

hope my question is clear.

Thanks

[sunny_talwar]

My bad, I think I was looking at 12/27/2015 instead of 12/27/2016..... I have modified my code also just in case you want to take a look. I have created a flag instead of creating two separate fields.

Best,

Sunny

[sunny_talwar]

Thanks for sharing the link raajaswin‌

Best,

Sunny

[#4]

Thank you very much for your assistance.