Function for Date Subtraction, exclude Weekends

[Tom G]

I need a way to subtract two dates to find the number of
days between them, but exclude any Saturday-Sundays.
Anyone have a function that's been written to do this?
tg

 

[Cheryl Fischer]

You might want to have a look here:

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

 

[Guest]

Great, looks like the dh CountWorkdaysA could be just the
ticket! Thanks much.
tg

 

[Cheryl Fischer]

Should you have problems in your query because of the array argument in
NetWorkDays, here is a link to a work-around posted by MVP John Viescas:

http://tinyurl.com/328a7