title: Exclude weekends and custom days (i.e. Holidays) from date calculations
body: <p>Currently, I am calculating a finish date based on the start date (DateTime) and duration (# of days), but my calculations do not take into account weekends or holidays.</p>
  
  <p>So, my solution is not correct. This was just a starting point.</p>
  
  <p>I read some articles out there and one approach is to create a gigantic calendar table that has all the weekends and holidays for the next 50 years. I guess the idea is to query a date range against the calendar table and subtract the # of weekends and/or holidays.</p>
  
  <p>The problem is the software I am working on allows users to set their own project calendar.
  Wouldn't the table become to large to maintain given that the software allows users to manage multiple projects?</p>
  
  <p>So, I guess my question how do I get started and what are some possible approaches to this problem?</p>
  
  <p>Basically, for each project task I need to calculate the task finish date given the START date and DURATION, but taking weekends and custom days(aka holidays) into consideration.</p>
  
  <p>Any ideas?</p>
  
  <p>BTW: I'm using SQL Server 2005. </p>