10 Replies Latest reply: Apr 5, 2016 5:28 AM by vijaykrishnamraju vegesna RSS

    Networkdays function to change non working days from saturday-sunday to thursday-friday

      Hi Folks,


      I have a requirement where we need to calculate the no of days between start date and end data.


      We can use the

      networkdays( start:date, end_date {, holiday} )


      but this function automatically excludes saturday and sunday.


      What i need is to exclude Thurday and Friday as non working days and include the saturday and sunday as working day while doing the calculation.

      Our client working days are Sat-Wed  and Thu-Fri as weekOff.



      So how can i use an logic to calculate the exact no of days.


      Please advise how to achieve it.

      Your suggestion is much appreciate.