AnsweredAssumed Answered

Working days calc from Filemaker support is inaccurate

Question asked by Stu412 on May 15, 2015
Latest reply on May 15, 2015 by raybaudi

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

 

 

Outcomes