RE: [office-formula] 6.9.13 NETWORKDAYS

[Eric Patterson <ericpa@exchange.microsoft.com>]

I meant to say:

I agree that we should aim for consistency.  IS29500 added new enums for WEEKDAY and WEEKNUM for weeks starting on Mondays.  For NETWORKDAYS and WORKDAY, new functions were added to support the fourth parameter and weeks beginning on Mondays.

For OpenFormula, perhaps additional ENUMS can be added to WEEKDAY and WEEKNUM to allow for consistency and to follow IS8601.

-Eric

-----Original Message-----
From: Eric Patterson [mailto:ericpa@exchange.microsoft.com]
Sent: Tuesday, February 24, 2009 1:43 PM
To: office-formula
Subject: RE: [office-formula] 6.9.13 NETWORKDAYS

I agree that we should aim for consistency.  IS29500 added new enums for WEEKDAY and WEEKNUM for weeks starting on Mondays.  For NETWORKDAYS and WORKDAY, new functions were added to support the fourth parameter and weeks beginning on Mondays.

For OpenFormula, perhaps additional arguments can be added to WEEKDAY and WEEKNUM to allow for consistency and to follow IS8601.

-Eric

-----Original Message-----
From: robert_weir@us.ibm.com [mailto:robert_weir@us.ibm.com]
Sent: Tuesday, February 24, 2009 1:07 PM
To: office-formula
Subject: RE: [office-formula] 6.9.13 NETWORKDAYS

Eric Patterson <ericpa@exchange.microsoft.com> wrote on 02/24/2009
02:15:57 PM:

>
> RE: [office-formula] 6.9.13 NETWORKDAYS
>
> Looking at NETWORKDAYS further, I see that the 4th parameter,
> Workdays is defined as a list of logical values for the days of
> week, starting on SUNDAY.
>
> ISO8601 defines a calendar week to be a "time interval of seven
> calendar days starting with a Monday".
>
> I propose that OpenFormula should use the same convention in this case.
>

Where it gets interesting is with the WEEKDAY and WEEKNUM functions, which
by default have the week starting on Sunday.  I believe Excel also has
that default with WEEKDAY.  However we do it, we should have some
consistency between these three functions.

-Rob

---------------------------------------------------------------------
To unsubscribe from this mail list, you must leave the OASIS TC that
generates this mail.  Follow this link to all your TCs in OASIS at:
https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php



---------------------------------------------------------------------
To unsubscribe from this mail list, you must leave the OASIS TC that
generates this mail.  Follow this link to all your TCs in OASIS at:
https://www.oasis-open.org/apps/org/workgroup/portal/my_workgroups.php