software

NETWORKDAYS is an extreemly usefull function especially in building timesheets.
This function is based on the United States of America system, but not all
the world has the same bank holidays, and in some countries one can also have
a working week with 6 days. I would suggest that somehow this function can
be customised by the user if possible.

Thank You
Albert M Bartolo----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

The holidays are configurable as you create a list of the holidays.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;albertmbquot; gt; wrote in message
...
gt; NETWORKDAYS is an extreemly usefull function especially in building
timesheets.
gt; This function is based on the United States of America system, but not all
gt; the world has the same bank holidays, and in some countries one can also
have
gt; a working week with 6 days. I would suggest that somehow this function
can
gt; be customised by the user if possible.
gt;
gt; Thank You
gt; Albert M Bartolo
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...id=b2db1793-aa
8e-44bd-aea5-34a180a3635damp;dg=microsoft.public.excel.misc
Dear Bob, thank you for your valid information, can you be so kind to tell me
how to do it ? and is there a way to configure a six day week instead of five
day week?
Your help will be greatly appreciated.

Thank You
Albert M Bartolo

quot;Bob Phillipsquot; wrote:

gt; The holidays are configurable as you create a list of the holidays.
gt;
gt; --
gt;
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from the email address if mailing direct)
gt;
gt; quot;albertmbquot; gt; wrote in message
gt; ...
gt; gt; NETWORKDAYS is an extreemly usefull function especially in building
gt; timesheets.
gt; gt; This function is based on the United States of America system, but not all
gt; gt; the world has the same bank holidays, and in some countries one can also
gt; have
gt; gt; a working week with 6 days. I would suggest that somehow this function
gt; can
gt; gt; be customised by the user if possible.
gt; gt;
gt; gt; Thank You
gt; gt; Albert M Bartolo
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt;
gt; www.microsoft.com/office/comm...id=b2db1793-aa
gt; 8e-44bd-aea5-34a180a3635damp;dg=microsoft.public.excel.misc
gt;
gt;
gt;


Hi albertmb,

to exclude holidays of your choosing list all holiday dates, one per
cell, somewhere on your worksheet, e.g. cells Z1:Z10 then use

=NETWORKDAYS(A1,B1,Z1:Z10)

If you want a six day work week (excluding Sundays) see here for some
suggestions

www.excelforum.com/showthread...ht=networkdays

You could also try listing all Saturdays within the holiday range.....--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=521515