Results 1 to 2 of 2

Thread: Day Count

  1. #1
    Join Date
    May 2003

    Unanswered: Day Count


    I need to populate a day count on a report. This day count is the number of business days it takes to complete a job. I know the following formula will give me the day count --

    DayCount = Date - JobStartDate.

    However, this day count should only consider "business days", which means it should not count weekends.

    Can someone give me a hand as far as how to take weekends or business days into the formula?



  2. #2
    Join Date
    Jan 2004
    Norwich UK
    I got around this problem by creating the following expression:

    Working Days: [actual days]*(5/7)

    NB.. you must always have Monday as a start date and Sunday as a finish date for this to work though

Posting Permissions

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