DateAdd working days taking Holidays into account

[Buck46]

I have seen lots of threads similar to this but non that quite fits the bill.

I want to write a function that adds a number of working days to a date. I need to take into account Holidays. The holiday dates I want to put into a table not hard code into the function.

How can I do this?

 

[mp9]

Allowing for holidays: FAQ181-261

Not allowing for holidays:

http://www22.brinkster.com/accessory/modules/003.shtml

http://www22.brinkster.com/accessory/

 

[oharab]

Have a look at:

http://mvps.org/access/datetime/index.html

for a load of date handling routines.

Ben ----------------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

"Where are all the stupid people from...
...And how'd they get so dumb?"
NoFX-The Decline
----------------------------------------------

 

[slreynolds]

See faq181-261