[OASIS Issue Tracker] Created: (OFFICE-2916) 6.10.14 NETWORKDAYShas inconsisten semantics.

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

6.10.14 NETWORKDAYS has inconsisten semantics.
----------------------------------------------

                 Key: OFFICE-2916
                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2916
             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
          Issue Type: Bug
          Components: OpenFormula
    Affects Versions: ODF 1.2 CD 05
            Reporter: Andreas Guelzow 


"6.10.14 NETWORKDAYS
Summary: Returns the whole number of work days between two dates."

appears to be the correct intention for this function. The Semantics section starts:

"Semantics: Returns the whole number of days between two dates, ignoring weekends.
Work days are defined as non-weekend, non-holiday days. By default, weekends are Saturdays
and Sundays and there are no holidays."

In view of the second sentence the first sentence conflicts with the summary. Since if we were only ignoring weekends we would not need the holidays specified. So I suspect that the first sentence of the semantics should be:

"Semantics: Returns the whole number of work days between two dates."



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira