<div>
Thanks Tim for the link. I have studied that article, the title is somewhat deceiving because they show a unique requirement of determining a date and excluding weekends. <br />
<br />
Yes, I am trying to remove weekends and holidays from the final results.<br />
<br />
Thanks
</div>


Thanks Tim for the link. I have studied that article, the title is somewhat deceiving because they show a unique requirement of determining a date and excluding weekends.

Yes, I am trying to remove weekends and holidays from the final results.

Thanks

<div>
Thanks Tim for the information. I appreciate it.
</div>


Thanks Tim for the information. I appreciate it.

<div>
<div class="content wysiwyg-content">
I am successfully calculating the difference between two dates (&quot;Start Date&quot; and &quot;End Date&quot;) using a calculated column named &quot;Project Length&quot;. The business requirements however are to factor in weekends and holidays in my final result. &nbsp; There is a function in Excel named &quot;NetworkDays&quot; that will do these type calculations in Excel, but it does not work in SharePoint 2010. Note: &nbsp;Adding an additional list to hold the holiday values is not a problem.<br />
<br />
If anyone has information about how to accomplish this, it would be greatly appreciated if you would let me know.<br />
<br />
Many Thanks...
</div>
</div>


I am successfully calculating the difference between two dates ("Start Date" and "End Date") using a calculated column named "Project Length". The business requirements however are to factor in weekends and holidays in my final result.   There is a function in Excel named "NetworkDays" that will do these type calculations in Excel, but it does not work in SharePoint 2010. Note:  Adding an additional list to hold the holiday values is not a problem.

If anyone has information about how to accomplish this, it would be greatly appreciated if you would let me know.

Many Thanks...

SharePoint 2010 - Calculated Column - factor in holidays and weekends in date difference formula

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.