Avatar of Walter Curtis
Walter CurtisFlag for United States of America

asked on 

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

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...
Microsoft SharePoint

Avatar of undefined
Last Comment
Walter Curtis
Avatar of Tim Edwards
Tim Edwards
Flag of Canada image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image


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.

Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image


Thanks Tim for the information. I appreciate it.
Microsoft SharePoint
Microsoft SharePoint

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.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo