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     www.energyefficientbuild.com.

user mhsraymond said: (http://productforums.google.com/forum/#!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).
OR
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