date difference excluding weekends

[Guest]

Hi,

I am trying to write a query that will count the number of days between two
dates but exclude weekends from the count. Any help would be greatly
appreciated

 

[Allen Browne]

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Guest]

If you don't want to use code, you can calculate in a query

Total DaysateDiff("d",[date field to start from],[date field to end from])
WeekendsateDiff("ww",[date field to start from],[date field to end from])
Total Weekdays:[Total Days] - ([Weekends]*2)

 

[Guest]

Mikedsn - thanks for this info, you've saved me alot of messing about

If you don't want to use code, you can calculate in a query

Total DaysateDiff("d",[date field to start from],[date field to end from])
WeekendsateDiff("ww",[date field to start from],[date field to end from])
Total Weekdays:[Total Days] - ([Weekends]*2)

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

 

[Aaron]

Thank you Mikedsn
--
..

Mikedsn - thanks for this info, you've saved me alot of messing about

If you don't want to use code, you can calculate in a query

Total DaysateDiff("d",[date field to start from],[date field to end from])
WeekendsateDiff("ww",[date field to start from],[date field to end from])
Total Weekdays:[Total Days] - ([Weekends]*2)

See:
Doing WorkDay Math in VBA
at:
http://www.mvps.org/access/datetime/date0012.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi,

I am trying to write a query that will count the number of days between
two
dates but exclude weekends from the count. Any help would be greatly
appreciated