office-formula message

Subject: Re: [office-formula] 6.9.13 Networkdays

From: Eike Rathke <erack@sun.com>
To: office-formula@lists.oasis-open.org
Date: Wed, 1 Jul 2009 12:39:08 +0200

Hi Eric,

On Friday, 2009-06-19 22:30:14 +0000, Eric Patterson wrote:

> weekend-number  Number  Indicates the days of the week that are weekend days and are not included in the number of whole working days between start-date and end-date. Values are shown in the table below.
> weekend-string  String  Indicates the days of the week that are weekend days and are not included in the number of whole working days between start-date and end-date.

I don't find that flexible enough. It doesn't allow to specify a 3 or
4 working-days week, e.g. if one is working only Tuesday to Friday.
Given that a NETWORKDAYS function probably is mostly used to calculate
project dates or payrolls, having that fixed set of weekend days IMHO
isn't sufficient.

  Eike

-- 
Automatic string conversions considered dangerous. They are the GOTO statements
of spreadsheets.  --Robert Weir on the OpenDocument formula subcommittee's list.

PGP signature