More on calculating differences between dates....

[PerryG]

I am familiar with the DateDiff and DateAdd functions, question is, is there anyway to not include weekends and holidays within the calculation? Perhaps the WeekDay function, but disallow values of 1 and 7 (eliminates weekends) but what about holidays? This is not critical yet, but will be soon. Has anyone faced this yet?

Thanks in advance for any/all help.

PerryG

 

[MichaelRed]

Perry,

There are a few FAQ threads on this subject. One of mine has a more-or-less complete example of the process to calculate "working days". As I am somewhat of a klutz, I have not figured out how to just past the "URL" to the FAQ here, so I can only suggest that you search the FAQ's for the phrase "working days". I'm pretty sure it is in the Ms. Access General Discussion FAQ, but again, being somwhat weak in many respects, I don't have this firmly in mind either.

(P.S. despite my many short commings, the posted example does work)



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[MichaelRed]

This is what I get when I try to Copy/Paste shortcut(s)

http://www.tek-tips.com/faqs.cfm?spid=181&sfid=261&CFID=8775942&CFTOKEN=40078484

"It" works, but other members appear to be able to place the "Name" reference to the FAQ topics in the replies. Much "nicer".



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[PerryG]

Michael-
Found your FAQ, looks good. Thanks for the help.

PerryG