Casio FC-200 Financial Consultant

[Albert Chan]

We can make the code more compact, with sign function.

PHP Code:

function sign(x) return x==0 and 0 or x/abs(x) end

function networkdays(A, B)      -- assumed date A <= B
    local W = A%7               -- weekday(A)
    if W==0 then W=1; A=A+1 end -- A Sun -> Mon
    local D = B-A
    local E = floor(D/7)        -- weeks
    return D-E-E - sign(D-7*E + W - 6)    
end 


Update: the code had a bug, when A falls on Sunday.
Shifting it to Monday fixed it, matched open-office networkdays() results.