Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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