Date Difference Exclude Weekends

In a query, how can you calculate the difference between 2 dates (Date1 and
Date2) but exclude weekends.

I am trying to return the number of working days between 2 dates.

I know DateDiff only works for all days and includes weekends.

Thanks in advance

See:
Workday Math
at:
http://www.mvps.org/access/datetime/date0012.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"NadSadBad" wrote in message
...
In a query, how can you calculate the difference between 2 dates (Date1
and
Date2) but exclude weekends.

I am trying to return the number of working days between 2 dates.

I know DateDiff only works for all days and includes weekends.

Thanks in advance

I don't know if there is one so I wrote my own in a module and call this
instead

Function DateDiffXWE(stDate As Date, fiDate As Date) As Integer
Dim nDays As Integer

nDays = 0
While stDate fiDate
stDate = DateAdd("d", 1, stDate)
If Weekday(stDate) 1 And Weekday(stDate) 7 Then
nDays = nDays + 1
End If
Wend
DateDiffXWE = nDays
End Function

"NadSadBad" wrote:

In a query, how can you calculate the difference between 2 dates (Date1 and
Date2) but exclude weekends.

I am trying to return the number of working days between 2 dates.

I know DateDiff only works for all days and includes weekends.

Thanks in advance