Calculate sum of working days of a dates list

[lotfiblo]

Hello,

I would know if it is possible to calculate sum of  working days of a dates list  (without taking a count Saturday and Sunday )

I know that this fonction : networkdays(start:date, end_date {, holiday}) can calculate nember of days between two dates

But what I would like to have, is a sum of working days of a dates list, I have tried this fonction but it doesn't work : sum(networkdays([Due date] , [Posting date])   

So, It is possible to have the sum of the working days of this list ???

Thank you in advance

Lotfi

[Anonymous · Accepted solution]

The function says to use StartDate, EndDate as parameters. You seem to use EndDate, StartDate since I assume that Posting Date is the start date and Due Date is the end date

[lotfiblo]

Hi,

Thank you for reply,

you are right, by inversing [Due date] and [Posting date] the function works very well.

Thank you very much Johannes

Lotfi