Re: [office-formula] Who's doing what this week,Redux (including a request to Stefan Nikolas)

[Eike Rathke <erack@sun.com>]

Hi Robert,

On Wednesday, 2007-02-14 14:14:08 -0500, Robert Weir wrote:

> The existing function deals with whole days. Excel explicitly defines it 
> that way.  Even if you give it a date serial number that is noon one day 
> to 5pm another day, it will not return a fractional number of workdays. 
> 
> I'm not suggesting we expand it to include such a feature.

If we enhance the function such that Excel can't calculate it anyway,
why not add fractional workdays if those fractions are given in a new
optional parameter array? This functions is used to calculate a deadline
or similar dates, so including/excluding fractional days seems a valid
approach to me. But as said previously, maybe just overkill.

  Eike

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