Weekday only in Datediff function ?

[Ken]

I'm trying to calculate the number of weekdays (Monday to Friday)
between two dates, I can use the Datediff function to get all days
between the start and end dates but can't figure out how to get the
number of weekdays only in the result, is this possible with functions
or does it require vba.
Thanks in advance for any help given.

 

[RuralGuy]

I'm trying to calculate the number of weekdays (Monday to Friday)
between two dates, I can use the Datediff function to get all days
between the start and end dates but can't figure out how to get the
number of weekdays only in the result, is this possible with functions
or does it require vba.
Thanks in advance for any help given.

I'll bet something on this link will help.
http://www.pacificdb.com.au/MVP/Code/Dates.htm
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Douglas J. Steele]

The DateDiff function, by itself, can't do it, but there are tricks you can
use if you're trying to avoid writing your own function.

Take a look at my September, 2004 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Joan Wild]

There's a 'Calculate Number of Working Days' function at
www.mvps.org/access in the Date/Time section

 

[Ken]

Thank you all for the help and links given it's appreciated, I'll
check these out.

Thanks again
Regards Ken.