ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   WORKDAY() results appear to be inconsistent... (https://www.excelbanter.com/excel-worksheet-functions/196440-workday-results-appear-inconsistent.html)

dplum

WORKDAY() results appear to be inconsistent...
 

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?


All times are GMT +1. The time now is 02:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com