NetworkDays formula in Calculated column
-
15 Mei 2012 3:51HII 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
Semua Balasan
-
15 Mei 2012 4:24
Hi Santhosh,
You can calculate the difference between the dates to calculate business days and exculde weekends , as shown in link below:
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
- Disarankan sebagai Jawaban oleh Sachwani 20 Mei 2012 10:15
- Saran Jawaban dibatalkan oleh Steven AndrewsEditor 22 Mei 2012 10:56
- Ditandai sebagai Jawaban oleh Jack-GaoMicrosoft Contingent Staff, Moderator 25 Mei 2012 9:35
.png)
