NETWORKDAYS

A

albertmb

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 "I
Agree" 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 "I Agree" in the message pane.

http://www.microsoft.com/office/com...5-34a180a3635d&dg=microsoft.public.excel.misc
 
B

Bob Phillips

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

albertmb said:
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 "I
Agree" 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 "I Agree" in the message pane.
Click to expand...
http://www.microsoft.com/office/community/en-us/default.mspx?mid=b2db1793-aa
8e-44bd-aea5-34a180a3635d&dg=microsoft.public.excel.misc
 
A

albertmb

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
 
Top