Google Spreadsheet Post #1058

*Yogi Anand, D.Eng, P.E.*ANAND Enterprises LLC -- Rochester Hills MI

*www.energyefficientbuild.com. Feb 27, 2013*

*user SteveL321*

*said:(*

*http://productforums.google.com/forum/?zx=3mq12ihdx8pi#!category-topic/docs/spreadsheets/2RK8TenKwVM*

*)*

*Count number or occurrences of each day in a date range, less holidays.*

*I'm hoping someone can help me with a formula. I need to know how many Mondays, Tuesdays, Wednesdays, .... Sundays occur in a given date range; less any holidays.*

*I've got the following:*

*E2 = Start Date*

*F2 = End Date*

*H2 = Day to count*

*Range of holiday dates = C2:C15*

*I've found a few solutions to count the days, but can't find / understand what i need to do to check it against the list of holiday dates.*

*Anyone know how to make this work?*

*I'd love to understand how the formula works as well.*

*Steve*

---------------------------------------------------------------------------------------------------------------------

in the following I have presented a step by step approach leading to the final solution ... a number of formulas used here can be combined together, however to meet the intent of the question poster, I have presented formula for each step separately although in the real world solution the formulas would be combined together