How do I count only the # of Weekdays in a query (between 2 dates)

[Louise99]

I have a query where I was using datediff() to count the days between two dates and it worked fine. Now I need to count only the number of WEEKDAYS between two dates. I just have run out of ideas. Anyone know how I can do this?



Thanks!

 

[fneily]

This shows how to calculate how many of a specific weekday there is between two dates:
Calculating weekdays between two dates in Access

http://office.microsoft.com/en-us/access/HA010550781033.aspx?pid=CH062526711033

For how many weekdays, see the article
September 2004: Working all day
at

http://www.accessmvp.com/djsteele/SmartAccess.html

 

[MichaelRed]

be careful. weekdays <> workdays. see the faq's for how to get the number of WORKDAYS between two dates. to et the workdays just do a count on the date range where weekday <> 0 or 7 (similar to VbSunday or VbSaturday?)



MichaelRed