Counting Days between two Dates excluding weekends

[Simon]

I would like to count the number of working days between two date,
For example a date on a Friday and a date on the following Monday will
count as 1 Day not 3 Days

Is there a way to do this in an query

Thanks

 

[Dirk Goldgar]

I would like to count the number of working days between two date,
For example a date on a Friday and a date on the following Monday will
count as 1 Day not 3 Days

Is there a way to do this in an query

You need to use a VBA function to do it. Here are some functions to do
"workday math":

http://www.mvps.org/access/datetime/date0012.htm

 

[De Jager]

I would like to count the number of working days between two date,
For example a date on a Friday and a date on the following Monday will
count as 1 Day not 3 Days

Is there a way to do this in an query

Thanks