4 Replies Latest reply: Apr 3, 2012 10:30 AM by Sunil Kenth RSS

    Calculating Networkdays using two dates

    Sunil Kenth

      Hi,

       

      I have a start date and a finish date and i would like to calculate the number of working days between the start date and end date.  At the moment, in the script i have [finish date] - [start date] as Days which give me a count, however this is not excluding the weekend and therefore the number is incorrect.

       

      i have also tried networkdays([finish date], [start date]) as Days but this just gives me a 0 and 1 flags.

       

      Does anyone know the syntax that i need to use?