Originally posted by darby249
Is there a way to calculate the number of days to complete something and only use work days? If I do a datediff using days it includes weekend days and does not give me an accurate picture.
There is always a way ... Just depends on how much you're willing to do ... Do you need to exclude holidays also?
No, I just need M-F. Holidays are fine. The expression I was using is =datediff("d",[datercd], [datecompleted]) which is fine. Just not a accurate picture. I have seen something in the past that calculates network days. I just can't find it now.