NETWORKDAYS: using correct funtion?
On Wed, 28 Nov 2007 15:48:10 -0500, Ron Rosenfeld
wrote:
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.
Here is a formula that adjusts the result to give a difference exclusive of the
starting date, as would result from "normal" subtraction/addition:
=NETWORKDAYS(ReleasedDate,DueDate)+IF(ReleasedDate <=DueDate,-1,1)
--ron
|