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).
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
No comments:
Post a Comment