Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    21

    Unanswered: date calculation

    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.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: date calculation

    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?

  3. #3
    Join Date
    Dec 2003
    Posts
    21
    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.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •