Sunday, September 16, 2012

yogi_Given StartDate And EndDate Write A Series Of Dates With Weekends And Holidays Removed

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #754   Sep 16, 2012

user mhsraymond said: (!category-topic/docs/spreadsheets/L--q-L-jTik)
Write a series of dates with weekends and holidays removed
I need a formula that will write dates from "start date" to "end date" while removing weekends and holidays (listed in a column).
A workaround that will filter a column of dates, removing weekends and a list of holidays. 
I know how to filter out weekends but I'm stuck on removing the holidays
following is a solution to the problem