Date + x to avoid holidays? (1 Viewer)

[alex_aqui]

Is there an easy way to take a date field and add 3 to it, but in the event where the +3 ends on a sat or sun, or pre definined holiday, it adds the correct number of days to get to the first day that works? (ie, weekday, non-holiday)

Thanks in advance.

 

[Fuga]

Maybe you can find something here:

http://www.access-programmers.co.uk/forums/showthread.php?threadid=36639

Fuga.

 

[vandewi]

I have some date functions that I have created that adjust for weekends and holidays. It is currently set for American holidays, but it can easily edited for any country. The functions are:
PrevWorkday: Returns the previous workday.
NextWorkday: Returns the next workday.
AddWorkdays: Provide a positive number to add that number of workdays, or a negative number to subtract. You do not have to use integers, 0.5 will add 12 hours.

If you would like me to send these functions to you, please send me an email. I will have to send it from home as I do not have outside email at the office.