Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula results inconsistent. CyberTootie Excel Worksheet Functions 3 October 15th 06 03:20 PM
NETWORKDAYS calculation returns inconsistent results Analowl Excel Worksheet Functions 1 August 30th 06 02:28 AM
IF function comare to identical amount but inconsistent results skhuon Excel Worksheet Functions 1 July 28th 06 10:07 PM
Inconsistent results with =LOOKUP? watkincm Excel Worksheet Functions 2 May 31st 06 08:21 PM
Inconsistent Array Count results Suzanne Excel Worksheet Functions 5 April 6th 06 05:02 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"