View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ann ann is offline
external usenet poster
 
Posts: 210
Default Network Days Count accuracy

I'm using this formula to count scheduling accuracy by workdays. When the
team delivers on the scheduled date, the result is "1", so I've added "-1" at
the end of the formula. I have a bigger problem, which is related. For this
criteria: target date - 09/01/05 and delivery date - 09/03/05 the result is
"-1", but should be "-2".

Any ideas on what's wrong with this formula?

=NETWORKDAYS(IF(COUNT(L15:O15),MAX(L15:O15),P15),P 15)-1