weekend query

  • Thread starter Thread starter Joel Allen
  • Start date Start date
J

Joel Allen

Hi there,

I have a query that does:

[End Date] - [Start Date]

and it gives me a number of days. This works, but I want it exclude
Saturday and Sundays. Is there a way to do this?

Thanks so much for your help.
Joel
 
Joel said:
Hi there,

I have a query that does:

[End Date] - [Start Date]

and it gives me a number of days. This works, but I want it exclude
Saturday and Sundays. Is there a way to do this?

Thanks so much for your help.
Joel
Click to expand...

Hi Joel,

There are a number of solutions for this and related problems (e.g.,
excluding holidays, etc.) I suggest you google groups for

count exclude weekends access

and browse the results to see what works best for you.
 
Back
Top