Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
networkday - datedif | New Users to Excel | |||
6 day/week function ie:networkday | Excel Worksheet Functions | |||
Businessday (Networkday) Function | Excel Discussion (Misc queries) | |||
Networkday Calendar | Excel Discussion (Misc queries) | |||
NETWORKDAY function problem - starting on weekends | Excel Discussion (Misc queries) |