business days vs. days

[spence]

Is there any way to create an expression that will
subtract five business days from a given date rather than
just five days? I have no idea if Access has the ability
to "know" the difference between a weekend and a weekday.

thanks in advance,
spence

 

[Allen Browne]

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Michel Walsh]

Hi,


You can use a VBA function, like the ones in
http://www.mvps.org/access/datetime/date0012.htm


Hoping it may help,
Vanderghast, Access MVP