Networkday question
 

If you enter DATE(2008,10,1) as the Start_date and 10/1/08 as the End_date it
shows a difference of N=1 workday. Which means the system is subtracting
39722 from 39722 and getting a total of 1.

If you enter DATE(2008,11,1 ) as the Start_date and 11/1/08 as the End_date
it shows a difference of N=0 workdays. Which means the system is correctly
subtracting 39753 from 39753 and getting a total of 0.

What is causing the difference when the same formula is used? Is this a
glitch in the system?

Networkday question
 

That's the way Excel counts it; start and end date the same means one day.
But 2008,11,2 is not a workday, so it doesn't count

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"gcw" wrote in message
...
If you enter DATE(2008,10,1) as the Start_date and 10/1/08 as the End_date
it
shows a difference of N=1 workday. Which means the system is subtracting
39722 from 39722 and getting a total of 1.

If you enter DATE(2008,11,1 ) as the Start_date and 11/1/08 as the
End_date
it shows a difference of N=0 workdays. Which means the system is
correctly
subtracting 39753 from 39753 and getting a total of 0.

What is causing the difference when the same formula is used? Is this a
glitch in the system?

Networkday question
 

1-Oct-2008 is a Wednesday, so there is one workday between 1-Oct-2008
and 1-Oct-2008. 1-Nov-2008 is a Saturday, so there are no work days
between 1-Nov-2008 and 1-Nov-2008.

Which means the system is correctly
subtracting 39753 from 39753 and getting a total of 0.

That's not how NETWORKDAYS computes its result. It isn't simple
subtraction.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 21 Oct 2008 11:17:18 -0700, gcw
wrote:

If you enter DATE(2008,10,1) as the Start_date and 10/1/08 as the End_date it
shows a difference of N=1 workday. Which means the system is subtracting
39722 from 39722 and getting a total of 1.

If you enter DATE(2008,11,1 ) as the Start_date and 11/1/08 as the End_date
it shows a difference of N=0 workdays. Which means the system is correctly
subtracting 39753 from 39753 and getting a total of 0.

What is causing the difference when the same formula is used? Is this a
glitch in the system?

Networkday question
 

On Tue, 21 Oct 2008 11:17:18 -0700, gcw wrote:

If you enter DATE(2008,10,1) as the Start_date and 10/1/08 as the End_date it
shows a difference of N=1 workday. Which means the system is subtracting
39722 from 39722 and getting a total of 1.

If you enter DATE(2008,11,1 ) as the Start_date and 11/1/08 as the End_date
it shows a difference of N=0 workdays. Which means the system is correctly
subtracting 39753 from 39753 and getting a total of 0.

What is causing the difference when the same formula is used? Is this a
glitch in the system?

No glitch.

NETWORKDAYS returns the number of whole working days between start_date and
end_date.

In this case, the word "between" is used in an INCLUSIVE sense and includes the
first and last days.

Your first formula returns a 1, because you have "1" working day (1 Oct 2008)

Your second formula returns a "0" because 1 Nov 2008 is a Saturday, which is
not counted as a work day by this function.
--ron

Networkday question
 

OK I understand, weekend the beginning of the month starts on a weekend it is
best to use the beginning date as the first working day

Thank you for your help

"Chip Pearson" wrote:

1-Oct-2008 is a Wednesday, so there is one workday between 1-Oct-2008
and 1-Oct-2008. 1-Nov-2008 is a Saturday, so there are no work days
between 1-Nov-2008 and 1-Nov-2008.

Which means the system is correctly
subtracting 39753 from 39753 and getting a total of 0.

That's not how NETWORKDAYS computes its result. It isn't simple
subtraction.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 21 Oct 2008 11:17:18 -0700, gcw
wrote:

If you enter DATE(2008,10,1) as the Start_date and 10/1/08 as the End_date it
shows a difference of N=1 workday. Which means the system is subtracting
39722 from 39722 and getting a total of 1.

If you enter DATE(2008,11,1 ) as the Start_date and 11/1/08 as the End_date
it shows a difference of N=0 workdays. Which means the system is correctly
subtracting 39753 from 39753 and getting a total of 0.

What is causing the difference when the same formula is used? Is this a
glitch in the system?