On 08/31/2009 06:49 AM, Karti wrote:
Dear Joe,
Thanks for the clarification. Is it possible to translate this
http://www.cpearson.com/excel/betternetworkdays.aspx in calc?
Sorry, that's more than I can get into right now. There are some basic
things there that don't even look familiar to me; I can only guess that
they are "Excel-isms" that are not available in Calc.
There is a link there to a VBA version of the routine. That might
actually be easier to get working in Calc.
Hopefully someone else will have some suggestions.
There is a request for enhancement of the NETWORKDAYS function, to
include a way to specify which weekdays are not workdays:
http://qa.openoffice.org/issues/show_bug.cgi?id=71059
You can register there and add your vote (up to two) or comment.
If I were doing this, I would first create a more general function that
returned a count of any weekday(s) between two dates. Then, the
NETWORKDAYS function is trivial and completely customizable:
DAYS(StartDate; EndDate) -
(COUNTDAYS(StartDate; EndDate; ("Sat", "Sun"))
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org