Issue 4152 - The function NETWORKDAYS accepts negative values as inputs, instead of giving error message.
Summary: The function NETWORKDAYS accepts negative values as inputs, instead of giving...
Status: CLOSED DUPLICATE of issue 3866
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 641
Hardware: PC Windows 2000
: P4 Trivial (vote)
Target Milestone: ---
Assignee: daniel.rentz
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-04-20 18:13 UTC by Unknown
Modified: 2008-12-08 15:17 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-04-20 18:13:30 UTC 
The function NETWORKDAYS (Start date;End date;holidays) doesn't work as 
expected when negative dates are given as parameters.The function should give 
an error that it cannot accept negative dates because dates cannot have 
negative values but the function outputs a value. For example,when 
-12.1.2002,-12.26.2002 and -12.24.2002 are given as parameters to the 
function,the functions outputs a value of -19,instead of giving an error 
message.
Comment 1 peter.junge 2002-04-22 09:15:45 UTC 
Hi Daniel,
I guess this 1 is 4 U.
Best regards, Peter
Comment 2 daniel.rentz 2002-04-22 11:49:47 UTC 
You have already written this bug. It has been commented and accepted.

*** This issue has been marked as a duplicate of 3866 ***
Comment 3 daniel.rentz 2002-04-22 11:51:39 UTC 
Duplicate