Access 2003 how to add working days with DateAdd function??

[Organised Angel]

Hi everyone

I'm doing a project at work and I'm managing most of it fine apart from one section where I need to calculate a due date. The due date is 5 working days after the date entered. I have a query and I've used the Due Date:DateAdd("d ","5",[Date]) calculation which does work out 5 days but is including weekends - I've tried substituting the "d" days for "w" days but still no luck! Help! I think I need a table of holidays but this is way above my talents (I'm an administrator not a programmer)

Thanks in advance for your help

[Rabbit]

If you're going to add 5 days, then you may as well add 7 days because 5 days will take you into/past the weekend.

If, you need to account for holidays, then you will need a table of holidays.

[RuralGuy]

You may find this link helpful: http://www.mvps.org/access/datetime/date0012.htm
...and then again you might not! ;)