NETWORKDAYS

Version 1.9

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Certified trainers will then respond within 24 hours (working days).

Support promotion: Post a question within 7 days of attending your course and get an upgrade to 12 months support! (Standard period 3 months)

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

NETWORKDAYS

Simon has attended:
Excel Introduction course

by - delegate Simon [6 posts] (2008 Mar 20 Thu, 11:31) Reply

I have created a formula using Excel 2003 that counts the number of days between 2 dates. However, although Excel has given a figure removing the weekends as required, it has not taken into account the Bank Holidays like the help file said it would.

How can I change the formaula to ensure that the Bank Holidays are taken in account?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Nov 25 Tue + 26 Wed	Bayswater	6	book now	£455	£515
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 1 Mon + 2 Tue	Bloomsbury	2	book now	£495	£495
2003	2008 Dec 4 Thu + 5 Fri	Bloomsbury	5	book now	£450	£485
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	5	book now	£475	£515
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	6	book now	£450	£475
Full Schedule: See all 37 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: NETWORKDAYS

by - trainer Rajeev gold contributer [462 posts] (2008 Mar 27 Thu, 16:43) Reply

Dear Simon

Thank you for attending Excel Introduction course. I hope that you enjoyed the course and benefited from it.

Unfortunately Excel has been programmed to exclude only the Weekends from the week when calculating the NETWORKDAYS function. You’ll have to specify any extra days which will be public holidays on separate cells.

Please refer to the attached Excel file where I have done a calculation and hopefully that will help you to understand where you need to modify your function. If there is something you are not clear about please press the reply button and ask for further clarification.

I hope this helps.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003

Attached files...

NETWORKDAYS Function.xls

NETWORKDAYS

Attached files...

Related articles

Excel tip:

Closing Multiple Workbooks quickly