Thread: NETWORKDAY
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephanie Stephanie is offline
external usenet poster
 
Posts: 93
Default NETWORKDAY

Arrive Scan Sort to Scan Index
Sort to Index QA
12/2/2008 10:15 12/2/2008 10:55 0:40 12/2/2008 11:52 0:57
QA Sort to QA HOURS
12/2/2008 13:03 1:11:00 2:48

Okay. Everything works great until a holiday or weekend gets in the mix.
I'm looking at =NETWORKDAY, but there are several problems.

....I'm wondering if the from and two dates have to be together. When I use
the formula =NETWORKDAYS(O21,U21,Holidays2009) I get 24:00 instead of 0:00.



Steph