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

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

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