SID-00280: Spreadhsheet plugin Working days error

Status:	Answered	TWiki version:	4.1.2	Perl version:	5.8.8
Category:	CategoryPlugins	Server OS:	RedHat Linux 5	Last update:	16 years ago

$WORKINGDAYS is returning invalid results. For example when I use %CALC{$WORKINGDAYS($TIME(2009/03/07),$TIME(2009/03/12))}%

it returns 2 though the actual workingdays are 4.

Am I missing something. Please help.

--Bharath

-- BharathReddyMeka - 2009-04-23

Discussion and Answer

Testing:

• $WORKINGDAYS($TIME(2009/03/05),$TIME(2009/03/12)) : 5
• $WORKINGDAYS($TIME(2009/03/06),$TIME(2009/03/12)) : 4
• $WORKINGDAYS($TIME(2009/03/07),$TIME(2009/03/12)) : 3
• $WORKINGDAYS($TIME(2009/03/08),$TIME(2009/03/12)) : 3
• $WORKINGDAYS($TIME(2009/03/09),$TIME(2009/03/12)) : 3
• $WORKINGDAYS($TIME(2009/03/10),$TIME(2009/03/12)) : 2
• $WORKINGDAYS($TIME(2009/03/11),$TIME(2009/03/12)) : 1
• $WORKINGDAYS($TIME(2009/03/12),$TIME(2009/03/12)) : 0

Indeed, this looks like a bug. Please file a report at TWikibug:SpreadSheetPlugin.

-- PeterThoeny - 2009-04-23

This is tracked in TWikibug:Item6253

-- PeterThoeny - 2009-04-26

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.