Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Networkdays returns 1
Hi,
I am using Networkdays to calculate the difference between two dates. But if the dates are the same, it returns 1, not 0. I have a workaround, but I am curious why subtracting two serial numbers that are the same produces 1 not 0. Thanks, Jay |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Networkdays returns 1
The NETWORKDAYS function doesn't give you the difference in days between two
dates, it gives you the number of day in the range. If your start and end dates are the same, then there is one day in the range (assuming that date is not a weekend)... the date itself. If you need the difference in days, then just subtract 1 from the value returned by the NETWORKDAYS function. -- Rick (MVP - Excel) "Jay" wrote in message ... Hi, I am using Networkdays to calculate the difference between two dates. But if the dates are the same, it returns 1, not 0. I have a workaround, but I am curious why subtracting two serial numbers that are the same produces 1 not 0. Thanks, Jay |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Networkdays returns 1
Jay,
That's how networkdays works. If you are due to work 2/4/2009 and do so finishing on 2/4/2009 I bet you would want paying for 1 days work. Mike "Jay" wrote: Hi, I am using Networkdays to calculate the difference between two dates. But if the dates are the same, it returns 1, not 0. I have a workaround, but I am curious why subtracting two serial numbers that are the same produces 1 not 0. Thanks, Jay |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Networkdays returns 1
Mike,
Thanks for the explanation - it's easy to understand when it's explained in financial terms. Jay "Mike H" wrote: Jay, That's how networkdays works. If you are due to work 2/4/2009 and do so finishing on 2/4/2009 I bet you would want paying for 1 days work. Mike "Jay" wrote: Hi, I am using Networkdays to calculate the difference between two dates. But if the dates are the same, it returns 1, not 0. I have a workaround, but I am curious why subtracting two serial numbers that are the same produces 1 not 0. Thanks, Jay |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why Networkdays returns 1
Rick,
Thanks for the explanation about the range. I understand now. Jay "Rick Rothstein" wrote: The NETWORKDAYS function doesn't give you the difference in days between two dates, it gives you the number of day in the range. If your start and end dates are the same, then there is one day in the range (assuming that date is not a weekend)... the date itself. If you need the difference in days, then just subtract 1 from the value returned by the NETWORKDAYS function. -- Rick (MVP - Excel) "Jay" wrote in message ... Hi, I am using Networkdays to calculate the difference between two dates. But if the dates are the same, it returns 1, not 0. I have a workaround, but I am curious why subtracting two serial numbers that are the same produces 1 not 0. Thanks, Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date returns always returns: 00 January 1900 | Excel Worksheet Functions | |||
networkdays | Excel Worksheet Functions | |||
NETWORKDAYS | Excel Discussion (Misc queries) | |||
NETWORKDAYS calculation returns inconsistent results | Excel Worksheet Functions | |||
NETWORKDAYS Help | Excel Worksheet Functions |