Was 10/2/2012 the start or end date? And what date did you use for the other date needed for this calculation?
startdate = current date = 10/3/2012
this also worked for me. (current date = start date)( Int ( ( endDate - 6 ) / 7 ) - Int ( ( Get(CurrentDate) - 6 ) / 7 ) ) * 5 + // the number of weeks times 5If ( Mod ( endDate - 6 ; 7 ) - 2 > 0 ; Mod ( endDate - 6 ; 7 ) - 2 ; 0 ) - // the number of weekdays of the last weekIf ( Mod ( Get(CurrentDate) - 6 ; 7 ) - 2 > 0 ; Mod ( Get(CurrentDate) - 6 ; 7 ) - 2 ; 0 ) // the number of weekdays of the first week
And why would the end date come before the start date?
That would seem to be a nonsensical pair of dates to use for this calculation in the first place.
You are correct that this calcualtion is not equipped to produce a negative value as it is basically a table lookup performed from with in a calculation.
the end date would come before the start date if it was overdue.
so my mistake, i didn't really understand the formula i was using.
i had used it before but i'm guessing i never got into the negative values!
looking through i see my negatives values were off.
the upside is networkdays will now give a nice link to the filemaker solution.
if anyone is interested in learning how the formula works in more detail this helps: