calculate a date based on today’s date +20 working days

[Paulb2]

I want to calculate a date based on today’s date, excluding holidays and weekends, ie if I enter todays date (26/11/13) into DateReceived, I want DateDue to show +20 working days = 24/12/13Obviously this would change over the Christmas period as we have 3 bank holidays, I have placed all holidays into a table.I am using Access 2003

[pbaldy]

Lots of methods out there. Here's one:

http://msdn.microsoft.com/en-us/libr...ffice.12).aspx