Calculated field - excluding weekends

[DagmaraGa]

Hi all, I've got calculated field created which counts for me number of days passed between Actual Start and Actual Completion days. It works well. but what it does not do - it doesn't exclude non-working day. Round(DATEDIFF(Actual Completion Date,Actual Start Date),0) Is there a way to exclude weekends from the calculation ? Thanks in advance Dagmara Garwell BAKKAVOR LTD

[VicAl]

Yes, you can use WEEKDAYDIFF. I've attached a table from the Advanced Reporting Course Booklet which I've found to come in handy on several occasions. But the WEEKDAYDIFF should work for you here. Vic Alejandro, PMP, CSM | IT Program Manager Denver Water | t: (303-628-7262) | c: (303-319-6473) "http://www.denverwater.org/"> http://www.denverwater.org INTEGRITY | VISION | PASSION | EXCELLENCE | RESPECT