RE: [office-formula] 6.9.13 NETWORKDAYS

[robert_weir@us.ibm.com]

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