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

    vasim chaudhari

      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.

       

      Regards