NETWORKDAYS

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/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)

"albertmb" <albertmb@discussions.microsoft.com> wrote in message
news:B2DB1793-AA8E-44BD-AEA5-34A180A3635D@microsoft.com...
> 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/comm...id=b2db1793-aa
8e-44bd-aea5-34a180a3635d&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

"Bob Phillips" wrote:

> 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" <albertmb@discussions.microsoft.com> wrote in message
> news:B2DB1793-AA8E-44BD-AEA5-34A180A3635D@microsoft.com...
> > 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/comm...id=b2db1793-aa
> 8e-44bd-aea5-34a180a3635d&dg=microsoft.public.excel.misc
>
>
>

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

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

You could also try listing all Saturdays within the holiday range.....