Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() The WORKDAY() function uses the following arguments... - Start_date - Days = the number of non-weekend and non-holiday days BEFORE or AFTER the start_date I'm experiencing results that do not appear to be consistent. Have a look at the file posted at http://dplum.com/excel/Project-Workdays.xls WORKDAY() seems to drop any decimal portion of the argument for "Days" and then adds 1 day... am I interpreting the results correctly? Since the "Days" argument asks for the # of days BEFORE or AFTER the Start_date then it would appear that the Start_date itself is not to be included in the Days argument -- is this correct? Also, why would the decimal value for the "Days" argument be ignored? Does this also have to be compensated for in assigning the value for this argument? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula results inconsistent. | Excel Worksheet Functions | |||
NETWORKDAYS calculation returns inconsistent results | Excel Worksheet Functions | |||
IF function comare to identical amount but inconsistent results | Excel Worksheet Functions | |||
Inconsistent results with =LOOKUP? | Excel Worksheet Functions | |||
Inconsistent Array Count results | Excel Worksheet Functions |