This content has been marked as final. Show 2 replies
Working days calc from Filemaker support is inaccurate
I've been working with the calculation on this page:
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.