troubleshooting Question

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

Avatar of Walter Curtis
Walter CurtisFlag for United States of America asked on
Microsoft SharePoint
3 Comments1 Solution747 ViewsLast Modified:
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...
ASKER CERTIFIED SOLUTION
Tim Edwards
Manager of Information Technology & Office Administration

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 3 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 3 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004