'ms access+course' - Working days between dates

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