NetworkDays formula in Calculated column

Question

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.

Thanks & Regards,

Sudheer

---

Thanks & Regards, Sudheer

Answer 1

Hi Sudheer,

Take a look at this forum discussion MOSS 2007-Networkdays formula

---

Dmitry

Lightning Tools Check out our SharePoint tools and web parts | Lightning Tools Blog

Answer 2

Hi Kaloshin,

Thanks for sharing.

I have come across this formula. However, it considers weekends only.

I need holidays to be excluded as well. 

Thanks & Regards,

Sudheer

---

Thanks & Regards, Sudheer

Answer 3

Hi Naga,

To exclude the holidays, please refer  the below link for a workaround:
http://blog.pentalogic.net/2008/11/working-days-weekdays-holidays-sharepoint-calculated-columns/

Thanks,
Simon

---

Simon Huang

TechNet Community Support