This forum is closed. Thank you for your contributions.

Remove From My Forums

NetworkDays formula in Calculated column

Question
0

Sign in to vote

HI

I am trying to use NetworkDays formula of excel in calculated column of SharePoint 2010.

I want to count days between two dates, excluding weekends and list of holidays falling between those dates.

Let me know if you have implemented this scenario.
Santhosh

Tuesday, May 15, 2012 3:51 AM

Answers

1

Sign in to vote
Hi Santhosh,

You can calculate the difference between the dates to calculate business days and exculde weekends , as shown in link below:

http://social.msdn.microsoft.com/Forums/en-US/sharepointcustomization/thread/d6a6b014-c09c-4436-9f18-0f151bae85b5

But it is hard to exclude the holidays , the work arround is you can keep Holidays in seperate list or extra column in same list, please find the link below for more details :

http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/

Regards,

Sachwani
- Proposed as answer by Pushp Sachwani Sunday, May 20, 2012 10:15 AM
- Unproposed as answer by Steven AndrewsEditor Tuesday, May 22, 2012 10:56 AM
- Marked as answer by Jack-GaoModerator Friday, May 25, 2012 9:35 AM
Tuesday, May 15, 2012 4:24 AM