View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS

Networkdays includes both the begin and end date in it's calculations. Just
subtract 1 to get the results you want.

Regards,
Fred

"CYNTHIA" wrote in message
...
A) B)
11/20/09 11/23/09

11/2/09 11/5/09

When I use the Network formula it says 4 days which is incorrect for the
11.20.09 date.

I use the formula NETWORKDAYS(A1,B1)

also when i use to calculate 11/2/09 and 11/5/09 which i know are not
weekend dates but regular business dates it says 4 days which is wrong its
3
days

I use the formula NETWORKDAYS(A1,B1)

Please help me