View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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