2 Replies Latest reply on May 15, 2015 2:21 PM by raybaudi

    Working days calc from Filemaker support is inaccurate

    Stu412

      Title

      Working days calc from Filemaker support is inaccurate

      Post

      Hi there

      I've been working with the calculation on this page:

      http://help.filemaker.com/app/answers/detail/a_id/5281/~/calculating-number-of-weekdays-%28work-days%29-between-dates

      The formula on the page;

      5 * Int ( ( EndDate - StartDate ) / 7 ) +Middle ( "0012345501234544012343340123223401211234010012340" ; 7 * (DayOfWeek ( StartDate ) - 1 ) + DayOfWeek ( EndDate ) ; 1 )

      It's inaccurate and misses working days off certain months when you set up the start and end dates.

      Has a bunch of numbers in the Middle ("") section which I don't wholly understand, but I suspect they may be the cause of the problem.

      Is anybody able to help cos I can't see FM support doing anything too quickly, despite my requesting further assistance.

      Thanks