This content has been marked as final. Show 4 replies
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?