'ms access+course' - Working days between dates

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.

'ms access+course' - Working days between dates

Working days between dates

Angeliki has attended:
Access Advanced course

by - delegate Angeliki [1 post] (2008 Jan 9 Wed, 15:49) Reply

Is there any way to work out the number of working days (excluding bank holidays) between two dates?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	5	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Working days between dates

by - trainer Richard platinum contributer [818 posts] (2008 Feb 7 Thu, 16:03) Reply

Hello Angeliki,

Hope you enjoyed your Microsoft Access course with BEST Training.
Thank you for your question regarding working out the number of working days (excluding bank holidays) between two dates.

In short there is no way to do this without using a piece of code using MS Access VBA. There is a function in Excel that is called NETWORKDAYS which will provide you with the answer you are looking for, but unfortunately there is no direct equivalent in Access.

I suggest that you look through the following information, and see if you can find something that suits your need.

http://www.access-programmers.co.uk/forums/showthread.php?t=37245

http://www.mvps.org/access/datetime/date0006.htm

http://www.tek-tips.com/viewthread.cfm?qid=1267783&page=9

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

'ms access+course' - Working days between dates

Related articles

Access tip:

Design View in Relationship window