On Wed, 28 Nov 2007 08:01:01 -0800, AFJr
wrote:

eventual solution:
=IF(A8=0,"",IF(A8=$C$5,0,NETWORKDAYS(A8,$C$5)))

C5 is Due Date
A8 is Released Date
C8 is result in days (+/-)

Senario: released date prior to due date:
C5 = 1-jan-07
A8 = 12-dec-06
C8 = 1

Senario: released date later than due date:
C5 = 1-jan-07
A8 = 2-jan=07
C8 = -1

Senario: released date equals due date:
C5 = 1-jan-07
A8 = 1-jan-07
C8 = 0


Thanks for everyones help who responded. Any idea why the docs with the
identical formulas wouldn't work the same?


That's often a problem with data, but if you post the errors you are seeing ...

Your first example, above, doesn't make sense as there are about 15 workdays
between 12/12/06 and 1-jan-07 (without the holidays argument).

Also, NETWORKDAYS always includes the first and last day, so if that's not what
you want, then you will need to subtract or add one from all of your results.

Awaiting clarification ...
--ron