Adding 3 weekdays to date

alwainwright

Registered User.
Local time
Today, 13:04
Joined
Aug 24, 2005
Messages
19
I'm an Access novice! I have a table with a library loan date field defaulting with today's date and a due back field. I want the due back field to show a date 3 weekdays after the loan date. I've tried using DateAdd("w",3,Date()) but this just adds 3 days, not weekdays. Does anyone know how do I get it to skip weekends? If I need to use VBA, please supply instructions for including the code, as well as the code itself. :confused:
 
I've searched in Access and on the web and haven't found the answer to this. I found an IIF code on the web that I tried to manipulate to do what I want. However, it wasn't accepted in the Expression Builder box so I don't know if I'm putting it in the wrong place.
 
Search these forums, this topic comes up at least once a month. There are many solutions and samples posted

Col
 
There is certainly a lot on the subject. However, I can't find anything that produces a date that is x working days after another date. Also, the answers do seem to be to use VB, which I have never used. I don't understand the code that's there, so I can't adapt it to my purpose, and I'm still no clearer where I should put a code if I had one. I'd be grateful for further guidance.

Thanks.
 
What do you want to do if the day after the weekend is a public holiday?

Col
 

Users who are viewing this thread

Back
Top Bottom