Next in thread → Next in month →

Re: [office-formula] 6.9.13 Networkdays

From
Eike Rathke <>
Date
2009-07-01T10:46:47+00:00
ID
Thread
Re: [office-formula] 6.9.13 Networkdays
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.
Next in thread → Next in month →