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
|