On Apr 16, 4:39 pm, "John Bartley K7AAY"
wrote:
Any suggestions as to what's going wrong?

NETWORKDAYS seems to count the workdays including the start and end
date.

For example, NETWORKDAYS(TODAY(),TODAY()) = 1.
So, NETWORKDAYS(TODAY(),TODAY() + 1) = 2, which is what you got.

Simply subtract 1 to get the result you expected to get. But make sure
the second date is greater than the first date before you do or else
the net workdays from today to yesterday will give you -2.

Cheers,
David G