How do I calculate the number of Weekdays in a query?

S

Satchmo368

I am trying to calculate the number of weekdays between two dates. I am
trying to do this in a query. It would be similar to the function in Excel
called NETWORKDAYS.
 
G

GarryD

Hi Satchmo,
Had the same problem and got sent a link, you can pick this up from my
question which was posted about 4 hours before yours, just scroll down to the
GarryD question and response. I have not tried yet but looks fine!

Good luck
Garry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2016 Project, adding a workday to custom field 0
Display weeks from a Milestone 0
Finding the proper style field and the numbered paragraph value within the style 0
Query for Month and Day against Date() 2
Calculating weekdays in Access 5
Days in a specific month 2
Query Criteria Not Working Using Weekday Function 2
how do I use networkdays function in Access queries 1

Top