CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS
 

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

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

CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS
 

What results are you expecting?

11/20/09...11/23/09 = 2 which is correct
11/2/09...11/5/09 = 4 which is correct

If you want a result of 3 for 11/2/09...11/5/09 then which date don't you
want to count? The start date or the end date?

What results do you expect for these dates:

11/2/2009 (Mon) - 11/2/2009 (Mon)
11/1/2009 (Sun) - 11/2/2009 (Mon)
11/6/2009 (Fri) - 11/7/2009 (Sat)

--
Biff
Microsoft Excel MVP


"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

CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS
 

On Thu, 3 Dec 2009 14:51:01 -0800, CYNTHIA wrote:

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

The "logic" of the NETWORKDAYS function is to include both the starting and
ending days. After all, if you were a worker, and your first day of work was
11/2/09 and your last day of work was 11/5/09, you would want to be paid for
four days and not three.

If you want to do simple subtraction, then merely subtract 1 from the
networkdays answer.
--ron