6 Replies Latest reply: Jul 29, 2015 4:34 AM by Andy Weir RSS

    How to calculate specific networkdays

      Hello All, I am using the following formula to calculate network days between two months and it works for consecutive months

      networkdays(min("End Date"),max("End Date"))



      Let's say...If I select January, February and March, the calculation will be OK

      If I select only January and March, the calculation WILL include the days from February which I don't want.


      Semester 1 2015=129 network days

      All Months.JPG

      Q1 2015=64 network days



      Jan and Mar 2015=44 days HOWEVER it counts the 20 from Feb


      Jan & Mar.JPG


      Any ideas on how to solve this? What other formula could I use?

      Thanks in advance!