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"))

       

      HOWEVER

      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

      Q1.JPG

       

      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!

      Jose