Using excel's "workday" function in Access

[Amileaux]

When I add the excel library in access then try and use a function from excel that is an "add in" it doesn't work. Is there something else I need to add other than the excel library? Example is the workday function in excel. Thank you.

 

[Mile-O]

Forget that, it can be slow referencing the Excel library, and do a search on bank holidays (probably the best term) as I've done a few functions that replicate this. It was a long time ago, however, so I can't recall the quality of them.

 

[Advertiser]

Use the DateAdd function and set the period to 'w' (weekday)

George

 

[Mile-O]

Use the DateAdd function and set the period to 'w' (weekday)

It doesn't, however, cater for other dates in arrays such as bank holidays and Christmas.